Topics
Started by
Posts
Last post
I have 460 indexes ona database with a fragmentation percentage at 30% or greater. I have a sproc …
13 replies
I want to review settings of overall system which includes , does anyone have standard list of thin…
6 replies
Hi All, I am working with backup and restores. We use to keep 4 days backups. There is a requiremen…
1 replies
I have come across tables where there is a clustered index with 2 columns, also a non clustered ind…
1 replies
We have an app that I think is abusing Query Notifications. And by abuse I mean trying to register…
1 replies
One of our BI devs is working on a parent-child package setup. We use a File System setup in SSIS i…
7 replies
Hi, We have SQL 2008 R2 SP2 CU10 on a ERP system. Recently, users will complain that it is very slo…
6 replies
Hi all, I got a table with 2M records, table size is about 12GB. A usual select query is executed t…
7 replies
Hi Guy, Do you have sample coding for handling deadlock.
3 replies
Hi SSC, I have a proc which currently receives XML messages one at a time from another application.…
1 replies
Hi, I have to create a view but the statements having Is it possible to delete rows using view in s…
1 replies
I need to create a view that counts in one of the colums. The tricky part for me is that it should …
6 replies
Hi folks, I've been running some SSIS packages to extract data from SAS using SAS Local Data Provid…
3 replies
Hello, SQL is not my strong point, Im more of a UI developer, unfortunately the DBA is away for the…
3 replies
All, Is it possible to rebuild and recover SQL cluster instance if cluster drives hosting system da…
3 replies
Viewing 15 topics - 5,401 through 5,415 (of 30,225 total)
You must be logged in to create new topics.