Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,566 through 20,580 (of 59,072 total)

RE: The Scientific Method: a call to action

Jeff Moden (5/26/2015)
robert.sterbal 56890 (5/26/2015)
Jeff Moden (5/26/2015)
At work, we have a Wiki and we have a "function repository" (most new ones are iTVFs, for sure).
Which wiki do you use?
Good question....
--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 10:52 am

#1800646
RE: A quick query puzzle:

pawankkmr 41145 (5/26/2015)
Complete list of Simple and complex t-sql puzzles at
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
This blog is useful for mid level developers , Strictly not for SQL Experts 🙂
Enjoy...
The problem with such puzzles...
--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 9:51 am

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

robert.sterbal 56890 (5/26/2015)
Jeff Moden (5/26/2015)
At work, we have a Wiki and we have a "function repository" (most new ones are iTVFs, for sure).
Which wiki do you use?
Good question. 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 9:33 am

#1800612
RE: Hack Us

We do penetration testing twice a year. Outside hacker agency does it for us.
As for the cut'n'paste thing... we call that "CPR" for "Cut, Paste, and Replace". 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 9:30 am

#1800611
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

Viewing 15 posts - 20,566 through 20,580 (of 59,072 total)