Viewing 15 posts - 2,686 through 2,700 (of 18,926 total)
Grant Fritchey (9/14/2011)
Although, the current database was frequently very small and very responsive, the situations where you had to create cross-database joins were a pain.
Why?
September 14, 2011 at 4:54 am
You've basically ask how can I make any car go faster.
No end really on that topic either!
September 14, 2011 at 1:18 am
Jan Van der Eecken (9/14/2011)
Darn, Johan beat me to it...Congrats from me too, Jeff!
Well deserved! And enjoy your free trip to the summit! May the Chops be with you 😉
The...
September 14, 2011 at 1:00 am
It was about time :-D.
Congratsy!
September 14, 2011 at 12:59 am
Jan Van der Eecken (9/13/2011)
Steve Jones - SSC Editor (9/13/2011)
They could even go to something like cloud services for production data and local servers for historical data.
Steve, please enlighten me,...
September 13, 2011 at 2:59 pm
output into @whatever
select * from whatever
Then you get the results back. Can't say if there's something better without seeing the whole code.
Other option would be to import the data...
September 13, 2011 at 2:56 pm
You would TAKE LOG BACKUPS.
In the event those are insufficient there won't be more than a few seconds between the time the app crashes and the alert was sent to...
September 13, 2011 at 2:55 pm
No, but this one is => http://sqlfool.com/2011/06/index-defrag-script-v4-1
September 13, 2011 at 2:53 pm
SQLRNNR (9/13/2011)
Ninja's_RGR'us (9/13/2011)
September 13, 2011 at 2:52 pm
Avalin (9/13/2011)
I will consider your inputs and take a discussion with my colleuges if we shall do this or not. It seems like...
September 13, 2011 at 11:48 am
Rokh (9/13/2011)
What the heck? Did I had a brainfart or something?Lol, thanks guys anyway.
We'll let you take the call on this one. 😀
September 13, 2011 at 11:45 am
scrap those from the group by and use only 1 query
, OrderQty, ScrappedQty
September 13, 2011 at 11:32 am
I've always use scope_identity because it was safer (sql 2000).
Since 2K5, the output clause exists which is a better tool IMHO.
September 13, 2011 at 11:30 am
Avalin (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Now you're starting to make a little more sense. But I still wouldn't do...
September 13, 2011 at 11:28 am
No my recommendation is to not waste time on something that has 0 benefit.
Now you're starting to make a little more sense. But I still wouldn't do it unless...
September 13, 2011 at 11:10 am
Viewing 15 posts - 2,686 through 2,700 (of 18,926 total)