Viewing 15 posts - 3,376 through 3,390 (of 7,503 total)
Select top 1
3 as LuckyExerciseNumber
, isnull([Title],'') + [LastName]
FROM [AdventureWorks].[Person].[Contact]
ORDER BY SUBSTRING(CONVERT(VARCHAR(40), NEWID()), 1, 8)
😀
October 23, 2009 at 6:12 am
Are you referring to exercise 3 of Ms Brawn course ? :hehe:
October 23, 2009 at 12:13 am
Keep in mind this reg key only influences if SQLServer will write a notification in its ERRORLOG file.
If you want an actual recording, regardless of this reg key setting, you...
October 23, 2009 at 12:07 am
You've had some hints above,.
Now, if this were on a RAID volume, this really shouldn't have been an error as long as the physical drives are still available to support...
October 22, 2009 at 1:39 pm
Jack Corbett (10/22/2009)
Change Update ORders to update O
As you have noticed, Jack used
...FROM
orders O JOIN
orders O2 ON
...
The O and O2 are called...
October 22, 2009 at 1:33 pm
1) compare the execution plans ! (and statistics)
2) is the hardware configration the same ?
( cpu , ram, disk , io chanels,..)
3) are these both dedicated sqlserver servers ?
4) other...
October 22, 2009 at 1:29 pm
You can do that .... The question is WHY would you !!!
If you have 64-bit available, use as much 64-bit software as you can !
(btw with x64 sql2005 with...
October 22, 2009 at 1:25 pm
I think that is a valid reason to install your test server with SP2.
The migration project is the factor that calls for this decision. !
When testing your migration, try to...
October 22, 2009 at 7:42 am
Just my 2ct...
In my prereq sheet, our window installers are using, I always request the disks to be formatted using the largest possible block size available.
I personally don't think...
October 22, 2009 at 7:35 am
So you should start with a "timeslot" table.
Did you read these wonderful articles ?
- The "Numbers" or "Tally" Table: What it is and how it replaces a loop. By...
October 21, 2009 at 7:01 am
I haven't encountered that behaviour.
We recently went the other way around.;-)
Maybe setting sqlservers "max server memory (MB)" config can help out.
October 21, 2009 at 6:55 am
Or the simple version:
Select distinct DATEADD(day, 0, DATEDIFF(day, 0, dt)) as DateOnly, AT, sysuser
from #T1
order by DateOnly, AT, sysuser
October 21, 2009 at 6:51 am
Did you use SQL2005 upgrade advisor to prepare your action ?
October 21, 2009 at 6:46 am
I prefer option A, but I would set the end date to a default value of '9999-12-31' and document it.
Point is to avoid the NULL.
Having the actual datetime data will...
October 21, 2009 at 6:45 am
I prefer option A, but I would set the end date to a default value of '9999-12-31' and document it.
Point is to avoid the NULL.
Having the actual datetime data will...
October 21, 2009 at 6:41 am
Viewing 15 posts - 3,376 through 3,390 (of 7,503 total)