Viewing 15 topics - 269,011 through 269,025 (of 283,894 total)
Topics
Started by
Posts
Last post
Buying a new data warehouse server, looking at storage. Option #1 is direct attach, probably a thre…
3 replies
If I currently have servers that the program files and data files were installed on the D drive - i…
16 replies
In creating a test environment by restoring a database as the test database, I've noticed the File …
4 replies
This answer implies that you would be moving the primary key constraint to the LAST_ORDER_DT also. …
6 replies
"Drop the primary key clustered index and create a new one on LAST_ORDER_DT" implies to me that you…
11 replies
I am exporting to Excel based on query against an SQL Server table and a lookup against an Access t…
7 replies
hi how can i import with dts a .sql file which contains sql statements like this: delete from tab_c…
9 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
2 replies
Does anyone have a script which will select the top x rows from every user table in a database? Th…
6 replies
create proc extractdata as begin tran if exists (select * from dbo.sysobjects where id = object_id(…
6 replies
I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing m…
2 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
3 replies
Hi All, what's the skinny on using table hints, (nolock), (rowlock) etc.. on Read-only databases? …
1 replies
Kinda dumb question --- sorry What are sql internals while altering tables - adding, updating, or d…
5 replies
How can I pass a table variable as a parameter to a stored procedure ? eg. create proc procname ( @…
2 replies
Viewing 15 topics - 269,011 through 269,025 (of 283,894 total)