Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,911 through 14,925 (of 59,097 total)

RE: The Value of Surveys

Both the Democrats and the Republicans found out both how wrong a survey can be and how it can actually sway what's going to happen if it's published in real...
--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)

June 10, 2017 at 5:57 pm

#1946309
RE: ROLLUP can be used here?

This will give you the same output as that which you posted...

DECLARE @OtherLimit INT = 6
;
WITH ctePreAgg AS
(
SELECT product_name =...
--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)

June 10, 2017 at 5:54 pm

#1946308
RE: Clustered indexing and Non-clustered indexing

Yes... might as well get it from the master herself. Do the following search. Any of the videos with "(MCM)" as a part of the link title are totally awesome.
--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)

June 10, 2017 at 12:22 pm

#1946306
RE: Missing green arrow on the sql server icon in object explore

Jacob Wilkins - Friday, June 9, 2017 7:36 PM
Jeff Moden - Friday, June 9, 2017 5:46 PM
--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)

June 10, 2017 at 5:13 am

#1946291
RE: Missing green arrow on the sql server icon in object explore

Jacob Wilkins - Friday, June 9, 2017 3:14 PM
On the other side of that coin, I'll use SSMS from the server running...
--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)

June 9, 2017 at 5:46 pm

#1946284
RE: Missing green arrow on the sql server icon in object explore

Ken Hemmerling - Friday, June 9, 2017 2:13 PM
*Sigh* It appears that there are some time you just need to connect to...
--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)

June 9, 2017 at 2:54 pm

#1946268
RE: Parse Data in SQL

~~Also be seriously aware that the return datatype for PARSENAME is NCHAR. It you're saving the output in a table somewhere, it will save trailing spaces even if the target...~~
--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)

June 9, 2017 at 1:12 pm

#1946254
RE: Clear all caches for index performance testing, every time?

I try to test as if it's real life. Yes, I clear cache at the start of a test because it's important to know what will happen and how long...
--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)

June 8, 2017 at 8:22 am

#1946003
RE: Why do some DBAs avoid DATETIME2?

Sergiy - Thursday, June 8, 2017 1:53 AM
Jeff Moden - Wednesday, June 7, 2017 9:52 PM
--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)

June 8, 2017 at 8:09 am

#1946002
RE: Why do some DBAs avoid DATETIME2?

David Burrows - Thursday, June 8, 2017 3:15 AM
Sergiy - Thursday, June 8, 2017 2:31 AM
--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)

June 8, 2017 at 8:02 am

#1945999
RE: Why do some DBAs avoid DATETIME2?

Sergiy - Thursday, June 8, 2017 2:31 AM
David Burrows - Thursday, June 8, 2017 1:57 AM
--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)

June 8, 2017 at 8:00 am

#1945998
RE: Best way to handle a table-based queue?

Bill Talada - Thursday, June 8, 2017 5:01 AM
I stopped using queue tables eight years ago when 2008R2 came out with filtered...
--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)

June 8, 2017 at 7:55 am

#1945996
RE: Best way to handle a table-based queue?

DesNorton - Thursday, June 8, 2017 4:10 AM
Jeff Moden - Wednesday, June 7, 2017 5:43 PM
--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)

June 8, 2017 at 7:38 am

#1945993
RE: Why do some DBAs avoid DATETIME2?

Yes. Almost identical.
I also just found out this also affects the DATE data-type when used in a similar fashion in the WHERE clause. That means that all those...
--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)

June 7, 2017 at 9:52 pm

#1945926
RE: Cumulative Update 9 and PowerShell...

bartedgerton - Monday, June 5, 2017 8:36 AM
FYI.. After I installed CU9 on my 2012 SP3 instances, the path for the SQLPS...
--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)

June 7, 2017 at 8:08 pm

#1945923

Viewing 15 posts - 14,911 through 14,925 (of 59,097 total)