Topics
Started by
Posts
Last post
Dear All, I have a set of relatively big tables with very high reads and writes occurring on them c…
10 replies
Suppose I have table with the following structure. CREATE TABLE [TAB].[tblWorkOrderSegInvoices]( […
17 replies
SQL Server Linked Server to Oracle literal Query is taking so much time and But Variable is working…
1 replies
Hi can someone help me optimize this query SELECT [nine_TransactionID] ,[nine_LastUpdate] …
1 replies
I hope someone can help. Using SQL Server 2008 R2 with SP2 (10.50.4042.0) I am getting the error '…
3 replies
A stored procedure (SP) has been created that deletes data in loop for each group. So if there are…
1 replies
If you run a query.... databasename.dbo.tablename how do I end up with a wait type of "(18ms)ASYNC_…
3 replies
I was reviewing a SQL Server 2008 data warehouse instance and noticed high latency on the TempDb fi…
2 replies
Hi All, I noticed recently that one servers SQL compilations per batch requests was rather high aro…
4 replies
So, I've read several articles, and seen a good presentation about how interleaving DDL and DML can…
2 replies
I have a table t1 with a primary key on the identity column of this table. Within the insert trigg…
4 replies
I am having performance issues with this query.. but not sure how to get it to run properly.. it go…
1 replies
Hi everyone. I recently came across a dev database in our organization that had no clustered indexe…
18 replies
How does SQL Server handle casts in the WHERE clause? Logical query processing (LQP) in SS says tha…
4 replies
Hi All, Currently I am having problem with running sql query from one VM to another VM. Here is how…
2 replies
Viewing 15 topics - 61 through 75 (of 635 total)
You must be logged in to create new topics.