Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,596 through 20,610 (of 59,098 total)

RE: The Scientific Method: a call to action

paul.s.lach (5/26/2015)
I am surprised that nobody has mentioned the obvious next requirement which is an accessible and searchable repository where people can research and find previously performed proofs to allow...
--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)

May 26, 2015 at 8:53 am

#1800593
RE: Compare this years data with last years data - day adjusted

ps_vbdev (5/26/2015)
many thanks guys ISOWEEK was spot on, never knew about that.
Thanks for the feedback. Just remember that some years have 52 weeks and some have 53. It's...
--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)

May 26, 2015 at 8:48 am

#1800589
RE: The Scientific Method: a call to action

Kyrilluk (5/26/2015)
It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password to the developers because of...
--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)

May 26, 2015 at 8:38 am

#1800581
RE: Usages for Powershell

Wayne West (5/26/2015)
Personally I like abusing languages to get them to do things they weren't really intended to do just to see if I can do it. I wouldn't do...
--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)

May 26, 2015 at 8:24 am

#1800571
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/25/2015)
Jeff Moden (5/25/2015)
TomThomson (5/23/2015)
LinksUp (5/23/2015)
When I see that Joe Celko has posted a message I know that some level of entertainment will be attained:rolleyes:. I...
--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)

May 26, 2015 at 7:06 am

#1800549
RE: Storing a Binary File in a Database

For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.
--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)

May 26, 2015 at 7:03 am

#1800548
RE: Storing a Binary File in a Database

Nice article but I guess I just don't understand why people think they need to write a CLR for this.
--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)

May 26, 2015 at 12:48 am

#1800480
RE: Selecting data from xml

Eirikur Eiriksson (5/24/2015)
Jeff Moden (5/24/2015)
I'm confused. I admittedly don't now much about XML as I avoid it like the plague but the file identifies an "XSD" file. Can't...
--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)

May 25, 2015 at 6:24 pm

#1800465
RE: Scale out SQL Server Databases

simon.harvey 41170 (5/25/2015)
There could be a whole lot of hidden costs as in rewriting stuff that no longer works.
Too true - I got the impression that even the SAAS costs...
--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)

May 25, 2015 at 6:18 pm

#1800463
RE: Very huge count of rows in sys.dm_tran_locks

Steel83 (5/24/2015)
Hi Experts,
I am having a QA system with SQL Server 2008 R2 , SP2 standard edition. The host is a VM with 8 VCPUs and 32 GB of RAM...
--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)

May 25, 2015 at 4:50 pm

#1800461
RE: Usages for Powershell

By the same token, I've seen people use PowerShell inappropriately (think "Hammer") for things that SQL Server can easily do... just like we've seen abuse with SQL CLR, Cursors, While...
--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)

May 25, 2015 at 3:42 pm

#1800456
RE: Are the posted questions getting worse?

TomThomson (5/23/2015)
LinksUp (5/23/2015)
When I see that Joe Celko has posted a message I know that some level of entertainment will be attained:rolleyes:. I guess he crossed some boundary. It seems...
--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)

May 25, 2015 at 12:55 pm

#1800433
RE: to find equal and opposite rows in a table

yb751 (5/25/2015)
Could you further explain why C is eliminated from your desired output? In fact we could use a little more info in general. Without knowing how A...
--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)

May 25, 2015 at 12:23 pm

#1800432
RE: how temp tables are assocated to deffred recompilation.

I agree with Gail. What problem are you actually having? Is there some sort of a performance problem that you're trying to fix?
--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)

May 25, 2015 at 12:18 pm

#1800431
RE: Tuning expensive query

The question that I also have is where are you returning this information to because no one will have the time to read even a thousand rows.
--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)

May 25, 2015 at 12:16 pm

#1800430

Viewing 15 posts - 20,596 through 20,610 (of 59,098 total)