Jeff Moden

Forum Replies Created

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

RE: Is the logic the same for these two queries?

Based on the fact that someone used the YEAR() function in one of the renditions of the code, can we safely assume that the t.tabdate column is a DATETIME column? ...
--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 12, 2017 at 12:24 pm

#1946447
RE: Parse Data in SQL

Ed Wagner - Sunday, June 11, 2017 12:52 PM
Yep - the MS Docs page is definitely wrong. I just created a test...
--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 12, 2017 at 8:02 am

#1946398
RE: Parse Data in SQL

If it were an NCHAR, you would need to be seriously concerned no matter what. I ran into this problem before with some system tables (can't remember which ones just...
--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 8:23 pm

#1946314
RE: Parse Data in SQL

Here's the link for the current definition of PARSENAME.
https://docs.microsoft.com/en-us/sql/t-sql/functions/parsename-transact-sql
But Books Online and the link above is incorrect. PARSENAME actually returns an NVARCHAR(128), which is the...
--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 6:23 pm

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

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