Topics
Started by
Posts
Last post
I’m working on a legacy DB and I notice that several of the procedures do joins on views. Some of …
5 replies
Hello, If SQL server writes mostly in 64k blocks why would one want to test with any parameter othe…
3 replies
Hi, I have the following query that returns most expensive queries. The issue with this query is th…
3 replies
Hi all, I have come across some code that does this: Truncate table Tablename Drop table Tablename …
3 replies
In our environment we have table which gets populated through multiple connections. Just a single i…
1 replies
Hi, Apologies if this is in the incorrect forum. I have created a trigger using the below code: CRE…
10 replies
Hello, I am confused with the clustered key in nonclustered indexes. Lets say if I have a table wi…
9 replies
I'm working on a performance tuning on a 3TB table and tried to rebuild an non clustered index and …
1 replies
I have a suspended process, performing a DELETE command. The last wait was on BROKER_RECEIVE_WAITFO…
1 replies
Hi i've a problem with the concurrent insert into a partitioned table. I have two processes which w…
7 replies
Hi All, Having a DB of 400GB,with 3 .ndf files and don't have any additional file group for indexi…
2 replies
Hi All, We have a production database which is busy throughout the day and need to generate report …
7 replies
Hi, In my execution plan i can see some warning like: 1. "Type conversion in expression (CONVERT_IM…
9 replies
I've run into issues in the past dealing with extremely poorly written queries with LINQ. I've been…
10 replies
Hi Guys, I have an index consolidating issue which I have not been able to find a definitive answer…
4 replies
Viewing 15 topics - 376 through 390 (of 636 total)
You must be logged in to create new topics.