Viewing 15 posts - 46 through 60 (of 2,838 total)
Phil Parkin (6/11/2015)
Sioban Krzywicki (6/11/2015)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 5, 2015 at 12:39 pm
RonKyle (6/5/2015)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 5, 2015 at 12:26 pm
Sean Lange (6/5/2015)
--EDIT--
The links had a couple invalid characters.
Jeff's fantastic article[/url]
This is one Sioban wrote on using a...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 1, 2015 at 8:19 am
Grant Fritchey (4/8/2015)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
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...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 3, 2015 at 6:57 am
Viewing 15 posts - 46 through 60 (of 2,838 total)