Viewing 15 posts - 76 through 90 (of 380 total)
Hugo Kornelis (4/21/2015)
quote]
As I said... Of your own making.
Nothing to...
April 21, 2015 at 8:07 am
Hugo Kornelis (4/21/2015)
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
This can be "fixed" by first storing...
April 21, 2015 at 7:53 am
andrew gothard (4/21/2015)
PHYData DBA (4/21/2015)
Hugo Kornelis (4/21/2015)
This can be "fixed" by first storing...
April 21, 2015 at 7:45 am
sknox (4/21/2015)
Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:
Stop that. Just... NO! :hehe:
April 21, 2015 at 7:31 am
Easy process of elimination answer. Although it makes no sense to me for a PIVOT to be in a recursive CTE...
😎
April 21, 2015 at 7:30 am
Hugo Kornelis (4/21/2015)
This can be "fixed" by first storing the results of the...
April 21, 2015 at 7:04 am
Ed Wagner (4/20/2015)
g.britton (4/20/2015)
Iwas Bornready (4/20/2015)
Wow. There seems to be a lot of bad feelings for Cursors and While loops out there.Justified, for the most part.
Yes, it's justified. ...
April 20, 2015 at 12:11 pm
Great Discussion Topic.
Both scripts are useless as SQL. This is a great example of CURSOR, FLOW Control, PRINT and general SQL misuse.
Never use an object until you understand...
April 20, 2015 at 10:21 am
GilaMonster (4/15/2015)
PHYData DBA (4/14/2015)
Then I would use SELECT count(*), GetDate() from <table name> to be certain.
Counting every row in the table just to see whether the table has a row...
April 15, 2015 at 7:36 am
GilaMonster (4/13/2015)
Sean Lange (4/13/2015)
GilaMonster (4/13/2015)
Not fixed. Large portions of the storage engine were rewritten between SQL 2000 and 2005.
I would say that rewriting the storage engine is what "fixed" the...
April 14, 2015 at 3:27 pm
sql-lover (4/10/2015)
I need 100% certainty. The DMV/count is needed to identify the table(s) with an empty set. A massive DDL change will be deployed against...
April 14, 2015 at 11:34 am
To anyone reading this thread. I know we went Off Topic there for a long period.
It seemed like an important subject and one I had data to...
March 26, 2015 at 3:13 pm
Wayne West (3/26/2015)
That's a lot of memory pressure!
It will use all that I set Max memory to until about 136 gigabytes.
Why?
Because the total Buffer Pool size of all...
March 26, 2015 at 2:56 pm
Wayne West (3/26/2015)
PHYData DBA (3/26/2015)
Wow....<many things were here>
Good Luck... 😎
It'll be interesting. Right now the database, at about a third its population, isn't even 10 meg. It's...
March 26, 2015 at 2:16 pm
Wayne West (3/26/2015)
PHYData DBA (3/26/2015)
Wayne West (3/26/2015)
How do you argue that you want as many spindles as possible to separate the DB, Log, and TempDB from each other to...
March 26, 2015 at 11:15 am
Viewing 15 posts - 76 through 90 (of 380 total)