Topics
Started by
Posts
Last post
I get the following error message when a job calls a Stored Procedure that TRUNCATES a Table: Canno…
4 replies
Ran the execution plan for the script and it showed 50% cost for Key Lookup(Clustered) and 50 %Inde…
7 replies
The field "content" in the table "catalog" can have this particular string "<DataSourceReference…
29 replies
Hello Guys, Below is a piece of code i'm working on to improve the efficiency of a purge, but i'm g…
3 replies
I need to move several database files to a different LUN, same server of course. I know what's the …
2 replies
After I performed mirroring failover , my outgoing replications from the database started failing a…
1 replies
Hi All, I have 20 tables to be archived. Am moving them to archive database from production and del…
1 replies
I am trying to insert datainto a table calling a procedure. INSERT dbo.TableA execute dbo.sp_Proced…
2 replies
How to find whether Microsoft visual studio or asp application accessing my SQL server?finding that…
2 replies
Hello all, Is it possible to have the same database be part of both an AG AND a mirroring session? …
6 replies
Used this script below to get index fragmentation: SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, …
2 replies
How do I capture information regarding top sql queries based on CPU usage and execution time?
3 replies
AFTER a DROP TABLE / CREATE TABLE command, some users who previously could SELECT from the table ar…
7 replies
Hi Gurus, I have found that a database is taking more than 50% buffer pool memory and I even locate…
7 replies
Hi , I am getting below error while trying to connect sql server remotely: Error : Cannot generate …
4 replies
Viewing 15 topics - 2,551 through 2,565 (of 8,636 total)
You must be logged in to create new topics.