Viewing 15 topics - 257,971 through 257,985 (of 284,019 total)
Topics
Started by
Posts
Last post
Is there a function like iszero li isnull where i can check zero eg: Select isZero(count(*)) from a…
5 replies
Hello DBA aficionados. I have been in the IT dept of my place of employment for a few years and for…
8 replies
Hi experts, I have a table only 250 MB which stores image files and the ID is the key …
4 replies
Can someone tell me what the difference is, if any, between a unique constraint and a unique index?…
5 replies
Hello, We have a large number of Intermediate and Aggegate tables that are populated daily. We have…
6 replies
I need help with the query below. The OpenedTot column has a value of 1 for each row which is not c…
5 replies
Hi, Our software product is licensed on number of CPU configured in SQL Server. We have been always…
5 replies
Hi I have a huge transaction log. I am not able to truncate the same. I h…
8 replies
Hi guys I am sure you can do this and I am missing something obvious.... I am writing a series of t…
1 replies
Hi, I want to do the following but I'm not knowing whether it would be possible in a single DTS …
12 replies
Basically I have 2 tables, I need to update a field in one if there is NO match to the other Update…
3 replies
Hi, Trying to use xp_cmdshell to copy/rename a file. the command is a simple copy x y statement, eg…
2 replies
OK, here's my problem: I have an orders table, oeOrders, which has a primary key based on a billing…
3 replies
Hi everybody, I want to see which value is the unicode comparison style of my SQL7 server, but…
1 replies
Is there any value in having more than one file for a transaction log? Does the size of the d…
11 replies
Viewing 15 topics - 257,971 through 257,985 (of 284,019 total)