Topics
Started by
Posts
Last post
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
0 1 2 3 4 5 6 7 8 9 |______X_______| *X is the active portion of the log* I have a question regardi…
2 replies
Can this be done? Can you construct a QUERY to give these results? Table 1 ========================…
9 replies
I tried using the first function it is not working. Can some one help me with some examples and syn…
3 replies
Hi, What "read only activity" can exist on databases? I am new to SQL and would like to find this o…
4 replies
Viewing 15 topics - 23,176 through 23,190 (of 30,225 total)
You must be logged in to create new topics.