Viewing 15 posts - 1,351 through 1,365 (of 2,647 total)
jpbbabin (3/21/2012)
March 21, 2012 at 11:52 am
Let's backtrack a bit... What is the ping time between the application server and the database server from command prompt?
March 21, 2012 at 11:13 am
Charmer (3/21/2012)
i try to run some T-SQL statements in ssms like insert and update left outer join with 5 tables...due to large records it takes too much time..
so if...
March 21, 2012 at 10:42 am
How do you know it is "too many?" What exactly are you basing that on?
March 21, 2012 at 10:38 am
capn.hector (3/21/2012)
in a partitioned table? i would delete the data you dont need then drop the partition from the table definition then delete the file.
Umm... No. In a partitioned...
March 21, 2012 at 10:36 am
I always say you need to ask yourself the following question: "What do I gain by partitioning?"
In our case, it helps with our backup strategy and querying. We partition by...
March 21, 2012 at 9:38 am
To build on what others are saying:
UNION or UNION ALL will combine 2 or more result sets vertically; essentially "stacking" them on top of each other. The # of...
March 21, 2012 at 8:39 am
Jeff Moden (3/21/2012)
March 21, 2012 at 7:48 am
I would start by looking at the winner of the deadlock and the losers. When both are run a the same time, what would be causing the deadlock? Can...
March 20, 2012 at 2:58 pm
Kenneth.Fisher (3/20/2012)
Shaurabh Thapa (3/19/2012)
The problem seems to be with sql 2008 setup support files. Just un-install setup support file and run the setup again.What does setupbootstrap logs says ?
Setupbootstrap logs...
March 20, 2012 at 1:54 pm
I'm not sure what you are looking for exactly, or why. However, I don't believe there is a place to simply generate a script for the queue object in...
March 20, 2012 at 1:36 pm
ColdCoffee (3/20/2012)
I dont see a triangular join here. Its pretty straight forward join. Or maybe im overlooking something here :blink:
Triangular join because the join condition is >=
March 20, 2012 at 1:26 pm
Why not put your derived table into a CTE as well? Or a temp table? It doesn't address the triangluar join yet, but that's the first thing I noticed. ...
March 20, 2012 at 1:17 pm
The GROUP BY technique advised before should work as expected for you. Did you try it?
You could include all columns in the grouping set if needed.
Why would you use both...
March 20, 2012 at 12:50 pm
adonetok (3/20/2012)
How to use DDL and DML?
Please look at the article in my signature by Jeff Moden.
March 20, 2012 at 12:49 pm
Viewing 15 posts - 1,351 through 1,365 (of 2,647 total)