Topics
Started by
Posts
Last post
Hi all, I optimized a query by replacing table valued function with LEFT JOIN, and managed to reduc…
3 replies
I have a challenge that I was hoping to solve using the new SQL Server 2012 running balance capabil…
21 replies
By: gcresse
I've got a 350 million row partitioned table that I'm trying to aggregate. The plan I get uses a H…
3 replies
Hi All, Can I short circuit WHERE clause in this query without using CASE... select * from company …
8 replies
By: e4d4
All 3 of these AS Clause below will work in MS T-SQL. But my question is which on is more proper ty…
1 replies
By default Oracle does everything in transactions. Once a I start a change the current state of the…
2 replies
By: Tobar
I have set up DDL events notifications using service broker. I now am trying to set up a trigger on…
2 replies
By: D-SQL
Can this query be written using LEFT JOIN to "person" as part of the FROM clause, rather than doing…
3 replies
By: T.Ashish
I am currently working on project where we are extracting data from some AX tables. The data from t…
18 replies
Hello guys, Are there any guidelines in giving an estimate with regards the storage for non-cluster…
2 replies
By: phebsix
Just moved from learning mysql to SQL Server 2012, and already having an issue. Here is my code: CR…
13 replies
I have tried pivoting - no success since the numbers of rows in the source table that have to tacke…
7 replies
I was asked to look at a query today that was taking a very long time to return. I waited 10 minute…
16 replies
Hi All, I have a table with more than 50 Million records. I am changing a PK column into …
2 replies
By: Lowell
Hi All, I have attached two queries with table definition and sample data. Query 2 is working bette…
13 replies
Viewing 15 topics - 4,831 through 4,845 (of 4,979 total)
You must be logged in to create new topics.