Topics
Started by
Posts
Last post
We have a new developer/DBA Trainee for our SQL Server 2008. He cannot open the SSMS Activity Moni…
1 replies
I've got the following peace of code that I use to find any transactions running for a long time: /…
2 replies
please some one help me, I have a sales table which has nearly 30 million records I want to paratio…
2 replies
For some reason, Object Explorer is not coming up when I select it from the View drop-down menu. I …
2 replies
This question has been asked probably 1000 times already but nowhere have I seen a clear answer (as…
11 replies
Hi All, I need to rename Foreign key/Default constraint name. With SP_RENAME I can rename primary k…
3 replies
I have a project where I need to migrate all objects to a new database (splitting from 1 file to 8 …
5 replies
hello im trying to use database mail to send emails with SQL but im with a big error atm don't know…
13 replies
Hi, I'm having some issues with a query that performs really poorly on TOP 1, but not on TOP n (whe…
22 replies
I have read countless threads/articles on this and still have the problem. Here is the history. Mo…
1 replies
I want to partition a table that already has a number of indexes, clustered and non clustered. Do i…
1 replies
Hi, Can you please let me know what the issue was . why it was taking 96% of physical memory OS : W…
10 replies
Hi all, Currently I am running SQL Server that is accessed from an app. the app requires smart card…
1 replies
Run the below query. When the value of @@TRANCOUNT never exceeds 1, why is 2 being written to the t…
5 replies
Hi there, I'm trying NOT to use a cursor/while loop, but getting stuck. I am very close, but runn…
1 replies
Viewing 15 topics - 23,161 through 23,175 (of 30,212 total)
You must be logged in to create new topics.