Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,226 through 18,240 (of 59,069 total)

RE: Are the posted questions getting worse?

Sean Lange (3/2/2016)
Ed Wagner (3/2/2016)
Sean Lange (3/2/2016)
Alan.B (3/2/2016)
Sean Lange (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 1:03 pm

#1862546
RE: Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook

Gary Varga (3/2/2016)
Steve, Luis,
Constructive criticism accepted. I was busy but that is not a good enough excuse. I thought that the title and URL were clear enough but as proven...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 12:18 pm

#1862521
RE: Free eBook today: SQL Server 2012 with PowerShell V3 Cookbook

Gary Varga (3/2/2016)
Hugo Kornelis (3/2/2016)
Reported as spam.
And a friendly reminder to anyone to be carefull when following links. This one might be legit, or it might be a virus. No...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 11:29 am

#1862507
RE: SP2 for SQL 2014....

Considering the recent track record for SPs and CUs, you might consider waiting for at least a month before you deploy either.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 11:26 am

#1862504
RE: Project ideas for DBA to advance in powershell

ebooklub (3/2/2016)
Hi,
Any help or links highly appreciated
My suggestion would be to first learn how to do the job of a DBA without the use of Powershell. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 11:23 am

#1862503
RE: Save file's name into a table

The code has been updated, tested, and reposted. Thanks for the feedback.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 8:21 am

#1862406
RE: Save file's name into a table

adonetok (3/2/2016)
Got an error said
Windowed functions can only appear in the SELECT or ORDER BY clauses
After comment out
--UPDATE #Order
-- SET FileOrder = ROW_NUMBER() OVER...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 8:20 am

#1862404
RE: House Keeping - Statistics

NicHopper (3/2/2016)
Hi,
I've not forgotten about this, I've just been busy, I'll do my best to get an article together with scripts in the next week or so.
Sorry for the delay.
Nic
Hi...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 8:13 am

#1862398
RE: Save file's name into a table

With the normal warnings about using undocumented features (which I frequently do, BTW), the following code will do what you ask and enable you to do more that you might...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 8:04 am

#1862396
RE: IDEs sweet but beguiling

Steve Jones - SSC Editor (3/1/2016)
Jeff Moden (2/29/2016)
...
How did they get that way?
By pointing and clicking and not being required to have any intellectual curiosity. Because the people they...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 12:31 am

#1862284
RE: How to get recursive CTE at least 3000 times faster?

For others interested in this post, Samuel had some additional information on a near identical post. I'm posting it below to try to "keep it all in one place".
samuel.johnson...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 12:24 am

#1862282
RE: How to get recursive CTE at least 3000 times faster?

samuel.johnson (3/1/2016)
You're right, I was unknowingly referring to MADs. I would hope to update daily. Nested Sets sound right on. In reference to my question at http://www.sqlservercentral.com/Forums/Topic1765709-373-1.aspx, how would using...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 2, 2016 at 12:18 am

#1862281
RE: How to get recursive CTE at least 3000 times faster?

samuel.johnson (3/1/2016)
I am projecting often to be at least 3000/year and up to at least 30,000/year. I have yet to design this update mechanism. I have trouble thinking in terms...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2016 at 9:08 pm

#1862274
RE: Can I improve performance by breaking my databases up?

This is nearly identical to another post. I recommend keeping any answers together on that other post, which is located at the following thread...
http://www.sqlservercentral.com/Forums/Topic1765710-3077-1.aspx
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2016 at 9:01 pm

#1862273
RE: 'Refresh' data only from Prod to Test environments

n.heyen (2/29/2016)
The development team is asking me to refresh data from Prod to Test without overwriting any stored procedures they might have on Test. So before I tell them no,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2016 at 8:59 pm

#1862272

Viewing 15 posts - 18,226 through 18,240 (of 59,069 total)