Topics
Started by
Posts
Last post
I’ve experimented with several variations but now I’m ready to call in the troops - I would like to…
3 replies
It might be my density :-), but looking at examples on the net I can not find a straight forward wa…
2 replies
Here's my SQL sequence: SELECT M.BoMWOID, CAST(SUM(M.BoMEstimatedMaterialCost) AS money) AS BoM…
7 replies
Hi all, When i try to add the '+@pDatabase+'.dbo. with the tablename in line 98,99,100 AM ge…
4 replies
Hi all, Here are two very small queries in which only difference is the use of DISTINCT. Both the q…
7 replies
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
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
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
I have set up DDL events notifications using service broker. I now am trying to set up a trigger on…
2 replies
Can this query be written using LEFT JOIN to "person" as part of the FROM clause, rather than doing…
3 replies
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
Viewing 15 topics - 4,831 through 4,845 (of 4,984 total)
You must be logged in to create new topics.