Topics
Started by
Posts
Last post
Hi. Background: I have two large tables. Both are clustered on a bigint IDENTITY column. The cl…
7 replies
Hi all Other that piecemeal restores what advantage is there in having multiple filegroups over hav…
3 replies
A working if statement is needed. CREATE PROCEDURE [IncCondense] (@latin INT) AS DECLARE @max …
2 replies
Hi, I have a SQL Server Agent job that calls an SSIS package. The first task of the SSIS package …
12 replies
Hi All, how to run a sql from other servers without using linked servers ? Thanks & Regards De…
12 replies
If Statement is not working IF (@max-@min)>290 BEGIN SELECT @col3 = SUM(Latin) FROM allcount; DE…
5 replies
I have a complicated update query involving values in 3 hierarchical tables. The top table 1, gr…
3 replies
How do you recommend the disk space needed for next 1 year. Based on my understanding we can get by…
2 replies
I have one really small table just having 25 rows and in that I have primary column with identity. …
4 replies
In doing some stored procedure tuning, I recently came across one that is trying to find all of the…
5 replies
Hello, I am having a hard time migrating an existing procedure we have on our production SQL Server…
3 replies
When I have a rollback transaction in the stored procedure and the parent script also has a begin t…
4 replies
In SQL Server 2008 R2 can someone please tell me how to shrink log file and also the data file. . I…
4 replies
Why windows group can't be mapped in linked server login mapping? I would like to understand reason…
1 replies
Hello, Our company is migrating a Microsoft Access 2010 backend database to a SQL Server 2008 datab…
4 replies
Viewing 15 topics - 7,981 through 7,995 (of 30,225 total)
You must be logged in to create new topics.