Viewing 15 posts - 5,416 through 5,430 (of 7,484 total)
GilaMonster (9/17/2011)
Evil Kraig F (9/17/2011)
The request? I thought we were just hoping to break Steve's spirit in general.CRAP, I've been doing it wrong again!;-)
Knowing Steve, it'll take far more...
September 17, 2011 at 2:35 pm
GilaMonster (9/17/2011)
WayneS (9/17/2011)
Steve Jones - SSC Editor (9/15/2011)
I'm going out of town for a few days....
September 17, 2011 at 11:50 am
As you are not specifying the parameter @query_result_separator, the separator in your attached file will be space, not comma, so it isn't a CSV file. If your data doesn't...
September 17, 2011 at 11:40 am
Personally I like dotted lines. It's more than 40 years since last I had a job where there weren't any, and I suspect that most people work with more...
September 17, 2011 at 11:20 am
Ray K (9/16/2011)
Tom.Thomson (9/16/2011)
Ray K (9/16/2011)
Daniel Bowlin (9/16/2011)
ZoomSchwartz
(Let's see if anyone picks up on this!)
Bifigliano
Tom wins the prize!
The hard part was choosing between Bifigliano and Profigliano.
No-one else chose either -...
September 17, 2011 at 10:08 am
okbangas (9/17/2011)
September 17, 2011 at 9:54 am
WayneS (9/17/2011)
September 17, 2011 at 8:51 am
If you have your database independent command sting in a varchar(??) variable @command, you can do something like
use master
go
begin
declare @crlf varchar(2)=char(13)+char(10)
declare @sql varchar(max) = ''
select @sql = @sql+'use '+name+@crlf+@command+@crlf+'go'+@crlf
...
September 17, 2011 at 8:42 am
okbangas (9/17/2011)
This is indeed the correct behavior if no rows are matching:
select SUM(ISNULL(object_id, 0))from tempdb.sys.objects
where type = 'X'
<rant>Correct only in that the mathematically illiterate cretin who determined this part...
September 17, 2011 at 5:19 am
GilaMonster (9/17/2011)
Tom.Thomson (9/17/2011)
Could domeone with a really good understanding of the interaction between indexes and locking have a look and join the discussion, please?
I already did, but seeing as I'm...
September 17, 2011 at 5:11 am
GilaMonster (9/17/2011)
Tom.Thomson (9/17/2011)
Maybe you need both for deadlock avoidance.
It's possible, but I wouldn't start with both on the off chance that a deadlock may occur.
Looks as if you were replying...
September 17, 2011 at 5:08 am
The responses to this question struck me as being carelessly wrong, so I jumped in with a contradictory response. Could domeone with a really good understanding of the interaction between...
September 17, 2011 at 4:51 am
Maybe you need both for deadlock avoidance.
This happens roughly as follows: Any query that updates one or more included values in one or more rows of the included values has...
September 17, 2011 at 4:44 am
ALZDBA (9/16/2011)
Tom.Thomson (9/16/2011)
5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new backup file...
September 16, 2011 at 4:58 pm
How large has your log file grown? If the database is in simple recovery mode, something strange must be happening to make log files grow large - maybe something...
September 16, 2011 at 3:18 pm
Viewing 15 posts - 5,416 through 5,430 (of 7,484 total)