Viewing 15 posts - 5,551 through 5,565 (of 26,490 total)
... Mark one off, 24 days on the calendar to go. 24 days on the calendar to go, 24 days to go, ...
February 3, 2015 at 8:37 pm
But the values in the Contact table can change, correct? What you have setup is a lookup table, and doing so is fine. You may find that you...
February 3, 2015 at 3:31 pm
RonKyle (2/3/2015)
There are cases where using a GUID as the primary key is valid. The problem comes if you also make it your clustered index.
These cases are rare. To...
February 3, 2015 at 2:56 pm
ScottPletcher (2/3/2015)
SELECT DOC_NO
,ENTER_DATE
FROM SALES_ORDER
WHERE ENTER_DATE >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 12, 0)
AND ENTER_DATE <...
February 3, 2015 at 1:20 pm
Like this:
declare @RunDate date = getdate();
select @RunDate, dateadd(year,-1,dateadd(month,datediff(month,0,@RunDate),0));
SELECT
DOC_NO
,ENTER_DATE
FROM
SALES_ORDER
WHERE
ENTER_DATE between dateadd(year,-1,dateadd(month,datediff(month,0,@RunDate),0)) and @RunDate --Need to...
February 3, 2015 at 1:13 pm
CELKO (2/3/2015)
I will study your advice and I'm appreciative that I have been flamed by the famous Joe Celko. I've heard that you are tough but I don't mind...
February 3, 2015 at 8:27 am
... Mark one off, 25 days on the calendar to go. 25 days on the calendar to go, 25 days to go, ...
February 3, 2015 at 8:22 am
jarick 15608 (2/2/2015)
It's...
February 2, 2015 at 2:10 pm
Who has the shovel? The horse came through again.
February 2, 2015 at 1:19 pm
Resender (2/2/2015)
I always do
WHERE 1 = 1
I can't remember where I picked this habit up and I'm one...
February 2, 2015 at 9:55 am
... Mark one off, 26 days on the calendar to go. 26 days on the calendar to go, 26 days to go, ...
February 1, 2015 at 9:05 pm
First, the png file really doesn't cut it. You need to post the DDL (CREATE TABLE statements) for the tables involved, sample data for the tables as INSERT INTO...
February 1, 2015 at 2:21 pm
Too soon after getting home. Maybe next year??
February 1, 2015 at 1:17 pm
xsevensinzx (2/1/2015)
Jeff Moden (1/31/2015)
Opinion respected and all of that is greatly appreciated but if the interviewer has to pull everything out of you rather than you volunteering some extra information...
February 1, 2015 at 9:38 am
Tac11 (2/1/2015)
So which level is fragmented 99% according to G. Berry's script? should I be worried about above result and run rebuild index job?
My guess, since you don't have the...
February 1, 2015 at 9:26 am
Viewing 15 posts - 5,551 through 5,565 (of 26,490 total)