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...
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...
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'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...
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...
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...
The current software package has over normalized data causing many queries to perform more that 3 joins (being modest). Therefore, we created a...
Separate names with a comma.
