Viewing 15 posts - 4,576 through 4,590 (of 18,926 total)
Tom.Thomson (7/22/2011)
tilew-948340 (7/22/2011)
I have SQL 2008 (but on XP professional for learning - not on a server machine - Would that make a difference?)
Yes, it makes a difference. Most...
July 22, 2011 at 5:34 am
Tx for the tests. As I said, It's nice to know it can be null or 1900-01-01, but I won't lose any sleep over this even if I don't...
July 22, 2011 at 5:26 am
BenWard (7/22/2011)
Ninja's_RGR'us (7/22/2011)
July 22, 2011 at 5:22 am
Toreador (7/22/2011)
malleswarareddy_m (7/22/2011)
Now onwards i will read the question properly.
How long I wonder before the next QotD where a literal reading of the question leads to the wrong answer, and...
July 22, 2011 at 5:02 am
Steve Jones - SSC Editor (7/21/2011)
It isn't a big deal, but if you are writing checks...
July 21, 2011 at 11:29 am
GilaMonster (7/21/2011)
1) catch the long running queries. Make note of the names/text of the ones you want to work on
2) A second profiler trace that...
July 21, 2011 at 11:14 am
GilaMonster (7/21/2011)
There's no extended event for actual execution plans, not even in Denali.
Ok so one none option eliminated.
July 21, 2011 at 11:05 am
Well let's explore it this way.
Couldn't I install express 2008 R2 [With advanced services] and configure the monitoring from there to an older version (I'd be very surprised if it...
July 21, 2011 at 10:43 am
Grant Fritchey (7/21/2011)
Have you tried using extended events. I'm know you can filter better there.
I'm on SQL 2K5. And apparently those features is new on sql 2K8.
July 21, 2011 at 10:36 am
Glad this is all sorted it.
July 21, 2011 at 9:58 am
halifaxdal (7/21/2011)
Ninja's_RGR'us (7/21/2011)
halifaxdal (7/21/2011)
Ignacio A. Salom Rangel (7/21/2011)
Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!
Sorry I thought I already posted.
I ran
DBCC CHECKDB('CheckListDB')...
July 21, 2011 at 9:45 am
Ignacio A. Salom Rangel (7/21/2011)
I'll shut up now let Gail take <back> over. Too many chiefs and too much noise going on at the moment.
Nobody is a chief,...
July 21, 2011 at 9:34 am
forsqlserver (7/20/2011)
looping
No need to post to get notifications.
Go to the top right of the thread and see the topic options menu.
July 21, 2011 at 9:26 am
Insert into dbo.OtherTable (FieldName)
SELECT [the SUM] = (DATEDIFF(minute, t1.[time], t2.[time]))
FROM
(
SELECT [time], row = row_number() OVER (ORDER BY [time])
FROM @TABLE
) t1
INNER JOIN
(
SELECT [time], row = row_number() OVER (ORDER BY [time])
FROM...
July 21, 2011 at 9:25 am
halifaxdal (7/21/2011)
Ignacio A. Salom Rangel (7/21/2011)
Halifax, could you please answer the question, made by Gail and Ninja? Thanks in advance!
Sorry I thought I already posted.
I ran
DBCC CHECKDB('CheckListDB') WITH NO_INFOMSGS,...
July 21, 2011 at 9:24 am
Viewing 15 posts - 4,576 through 4,590 (of 18,926 total)