I am trying to make sense of the Connection Memory performance counter. I understand what the value is returning. I am just tryiing to wrap my...
I am trying to troubleshoot a timeout issue with SQL 2k and .NET. I have scoured the interent and alot of people are having this problem but no one...
I use check constraints all the time and I am aware of their benefit. But it also seems that rules have some benefit as well. Therefore my question...
Can you bind a rule to multiple columns? I would like to set up a general business rule which satisfies many different scenerios. I'm big fan of...
Thanks for responses guys. Does anyone care to break the tie? -chili
I have created a stored procedure which deletes from about 15 tables (some of which have triggers). I do not wish for these triggers to fire so I...
I understand this concept. I was trying to convey that lock-escalation to the table level is not a bad thing. Many people think this is the case...
From what I understand about locking, row-level locking is more resource intensive. Therefore a table lock requires less resources which is a good...
Thanks for the info, What I gather from this article is there is little performance difference or impact between the two? -chili
I'll bet your paycheck this thread has been posted before. But hey, repetition is a good thing... I hope? How does SQL2k handle the distinct...
Disregard my last post! Sorry Bambola I did not read your last post in its entirety. Reading before writing can be helpful. -chili
So this scenerio is something better served for smaller tables? A very large table with wide columns could be dangerous? -chili
I will re-phrase my question. Has anyone encountered the following scenerio? -created a clustered index with multiple columns -created a...
Thanks Gauray but my question derived from the very article you are suggesting. My question is pointed at scenerios not optimizing a non-clustered...
This database has several tables with multiple columns for the clustered index forming a composite. In addition, they have made the individual...
I am trying to run the Index Tuning Wizard on a particular trace table and am getting a connection error. The preverbial 'connection to server is...
Thanks for the response. I do understand that. Therefore I need to clarify. I need to accept a datetime parameter. Then concatonate that...
What is the best way to use the datetime data type in a stored procedure as a parameter? I have created a stored procedure which exports data to an...
Hey all, I am trying to use the OPENDATASOURCE syntax to read an excel spreadsheet. I have having a terrible time trying to get this to work. Has...
I am trying to read an XL spreadsheet using T-SQL. Specifically the OPENDATASOURCE syntax. I am having a terrible time getting it to work. Has...
Separate names with a comma.
