Viewing 15 topics - 274,036 through 274,050 (of 284,037 total)
Topics
Started by
Posts
Last post
Is there a way to determine when the last time an Index was used in a query plan. We have numerous…
3 replies
Greetings, I have a query which returns around 800 records. In the WHERE clause I have various cond…
11 replies
Hi all! Last sayurday my production box went down. When the server becomes available again, my link…
2 replies
I have 2 nightly jobs which create a full backup of master and msdb. On Friday I noticed that the …
1 replies
This produces the correct results when run from Query Analizer: select name, xtype from sysobjects …
5 replies
Hi there Currently, we are planning to implement failover clustering in our environment. However, …
2 replies
Hi all, My SQL2K has over 100 tables and some triggers for tracking who deletes records. I intend t…
16 replies
When the optimization job runs against my database I get the fllowing error: [Microsoft SQL-DMO (OD…
3 replies
I understand that: declare @table table ..... declare @dynSql = 'select .....' Then how to popluate…
7 replies
I use the following query to get top 20 logins that eat most CPU resources. I need to change it, s…
2 replies
I've been having a debate with my infrastructure colleagues over the best RAID choice for SQL Serve…
4 replies
Hi all, does anyone know hot to dynamically change the database context in sql server 2000 ? For ex…
7 replies
I have a DTS package that I need to run and basically create a new excel file everytime it does. Wh…
16 replies
how would I trim trailing spaces and zeros from a string like this ? "345.2300" to get "345.23 and …
10 replies
I have an old system that I need to import data from. The database exports to a text file; each fie…
4 replies
Viewing 15 topics - 274,036 through 274,050 (of 284,037 total)