Topics
Started by
Posts
Last post
After performing an ALTER PROCEDURE, is it possible that any executions of that procedure would sti…
5 replies
I have been tasked at work to come up with a report that shows, by database, how many deadlocks hav…
2 replies
Hey Guru's, Lets say you have DB's log shipping from A to B in stand-by-mode so the DB are readable…
10 replies
Environment Details: DB is set to FULL: TLOG backup every hour: Size of the .ldf file is 9GB, autog…
7 replies
Hi There, how do I know if I should create an Non clustered Index on a Clustered Index or on a heap…
2 replies
Hi We are currently loading data into our databases via a DMT. The databases are using simple recov…
2 replies
This morning my CPU usage is EXTREMELY HIGh ..it is around 97 %.. I check the open transaction usin…
6 replies
Hi all , I would like to set time out in my Query (Transact SQL). I want to set for example 10 mins…
2 replies
How can I insert the result of below dynamic openquery into an existing table DECLARE @TSQ…
2 replies
THIS IS SQL Server community and education site.Please stop posting something that does not have to…
1 replies
I have two tables where the key of one doesn't not perfectly match the primary table. I have three…
16 replies
When doing a sql database restore from backup, I thought the 'with replace' option was required to …
7 replies
Hi Team, Using (UPDLOCK, READPAST) am trying to insert records into a table with two queries. but o…
2 replies
Is it possible to create 2 linked servers in 2 different domains that are not in the same forest? I…
2 replies
Hi, I want to order the VARCHAR datatype column which has parent-child hierarchical concept. I trie…
4 replies
Viewing 15 topics - 5,716 through 5,730 (of 30,225 total)
You must be logged in to create new topics.