Viewing 15 topics - 276,076 through 276,090 (of 284,066 total)
Topics
Started by
Posts
Last post
Hi everyone, is there a way to find out the size of each table in my database?
3 replies
We have a simple UPDATE statement that is really chewing up CPU time (~8000 in profiler) The durat…
9 replies
i have a variable to which i want to assign the value from a specific field in the 6th row of a rec…
7 replies
Trying to use DTS to read a variable length file. File is 100 cols but if last char is in col 60 t…
1 replies
I'm trying to figure out a process so that our company can automate db schema's in the field via an…
2 replies
Does anybody have any input on the effectiveness of Quest Software SQL Server database monitoring t…
5 replies
Can someone please explain the difference between these two statements? SET ANSI_WARNINGS OFF SET A…
1 replies
My select statement is as follows: SELECT L.[DATE],E.* FROM SAFETYLOGS2.DBO.LOGS AS L INNER JOIN OP…
1 replies
I know cursors are frownded upon but since this is for an infrequent utility I'm not overly worried…
1 replies
We are using Win2k/sql2k. I have a user who runs a .bat file that executes dtsrun. The user name …
6 replies
this is both a SQL question and a general question. I have seen multiple examples in SQL BOL that …
5 replies
Yesterday I did a DTS to copy a table from a QA server to production server. However the developer…
3 replies
I am using the -HtmlRpt option with a transaction log backup. Is there any way to append to the ht…
1 replies
I know you can use "replace" to remove carriage return or line feed from a varchar field but I am n…
4 replies
Is it possible to have a variable name in the FROM clause of a SELECT statement. For example I want…
7 replies
Viewing 15 topics - 276,076 through 276,090 (of 284,066 total)