Viewing 15 posts - 46 through 60 (of 2,837 total)
Phil Parkin (6/11/2015)
Sioban Krzywicki (6/11/2015)
June 11, 2015 at 7:18 am
Microsoft has always, always released what they had and then improved it later. Every product they have has gone through this. The initial products were frequently derided, but after a...
June 11, 2015 at 6:55 am
Brian J. Parker (6/5/2015)
RonKyle (6/5/2015)
That's a different but interesting topic. For that I have a separate Holiday table.
I agree that that's a better way. It's been on my list...
June 5, 2015 at 3:41 pm
RonKyle (6/5/2015)
Still no reason to go to a cursor.
I only use(d) a cursor to initially populate the dates. The susquent updates, including the holidays (each holiday date individually typed...
June 5, 2015 at 1:03 pm
RonKyle (6/5/2015)
Why would the day being a holiday be a problem?
It's not a problem, it's just that there's no date function for that and unlike almost all the others has...
June 5, 2015 at 12:39 pm
RonKyle (6/5/2015)
June 5, 2015 at 12:26 pm
Sean Lange (6/5/2015)
--EDIT--
The links had a couple invalid characters.
June 5, 2015 at 9:33 am
RonKyle (6/5/2015)
Populating a date dimension can be done using a tally table. No loop necessary.
The code executes faster but it is also a LOT simpler to write than a loop.
The...
June 5, 2015 at 9:18 am
Sean Lange (6/5/2015)
Brian J. Parker (6/5/2015)
Alan.B (6/5/2015)
RonKyle (6/5/2015)
cursors are there to be used for admin scripts to be executed manually
I like this caveat, especially as it now excuses my one...
June 5, 2015 at 9:09 am
g.britton (6/1/2015)
pietlinden (6/1/2015)
Here are some places where you might consider a cursor...
Here are places where...
June 1, 2015 at 11:48 am
There are absolutely times to use cursors. Creating a procedure to automatically rebuild or reorder indexes throughout your entire database is one.
The "Don't use cursors" is primarily a warning to...
June 1, 2015 at 8:19 am
Grant Fritchey (4/8/2015)
April 8, 2015 at 8:28 am
SqlSanctum (4/3/2015)
Brandie Tarvin (4/3/2015)
djj (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good...
April 3, 2015 at 8:08 am
Brandie Tarvin (4/3/2015)
djj (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday...
April 3, 2015 at 7:58 am
Koen Verbeeck (4/3/2015)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last...
April 3, 2015 at 6:57 am
Viewing 15 posts - 46 through 60 (of 2,837 total)