Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,656 through 17,670 (of 59,069 total)

RE: Scanning for a specific value in all the tables

rahulsahay123 (5/16/2016)
We have an OLAP system where we are assigning 0 value to any uniqueid column if the data is not following the business rule.
eg we have the following...
--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 16, 2016 at 5:44 am

#1879202
RE: Splitting Strings in SQL Server 2016

@etheral1980,
Understood. But that's how it all starts and your example is exactly what I'm talking about. It seems totally harmless right now.
--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 16, 2016 at 5:28 am

#1879193
RE: INT to DATE vs STRING to DATE

karthik M (5/13/2016)
All,
I have a thought on converting integer value (whereas date is stored in INT format) to Date. The same column is declared as char(8), so the convert...
--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 15, 2016 at 2:38 pm

#1879154
RE: Splitting Strings in SQL Server 2016

etheral1980 (5/14/2016)
Good to know there would be built in function to split string now. And i have various ways to use them.
But right now i use function which can work...
--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 15, 2016 at 12:52 pm

#1879147
RE: Create Dev VM by Cloning Production VM

Hold the phone a minute. If the production database is under TDE, why on Earth would you copy it to a Developer's box? Sale of private/sensitive information doesn'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 15, 2016 at 10:34 am

#1879142
RE: Dynamic data masking feature

Steve Jones - SSC Editor (5/14/2016)
None, or negligible. This merely replaces the string being returned with some pattern.
That's what a lot of people surmised about the relatively new FORMAT function,...
--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 15, 2016 at 10:27 am

#1879141
RE: t-sql 2012 date 1900-01-01

wendy elizabeth (5/14/2016)
In a t-sql 2012 statement where values are inserted into a table, the data is stored in the date column has a value 1900-01-01. I know this is...
--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 15, 2016 at 9:52 am

#1879138
RE: Excel spreadsheet to SQL Server table

SQL!$@w$0ME (5/13/2016)
Hello guys,
I have a requirement to load data from excel spreadsheet to SQL server table and need to automate it. I believe this can be implemented with SSIS.
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 15, 2016 at 9:17 am

#1879136
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (5/14/2016)
Jeff Moden (5/14/2016)
IMHO, no. It shouldn't return a NULL when the delimiter is NULL. It didn't find any NULLs as delimiters and, just like not finding 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 15, 2016 at 8:45 am

#1879135
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Alan.B (5/13/2016)
Something I don't understand:
SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');
Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.
SELECT * FROM dbo.DelimitedSplit8K(NULL,',');
Returns a NULL. This makes...
--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 14, 2016 at 10:12 am

#1879098
RE: Are the posted questions getting worse?

Eirikur Eiriksson (5/13/2016)
Jeff Moden (5/13/2016)
jasona.work (5/13/2016)
So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all...
--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 13, 2016 at 1:01 pm

#1879030
RE: Are the posted questions getting worse?

jasona.work (5/13/2016)
So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all things pork chop launching,...
--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 13, 2016 at 11:13 am

#1878981
RE: How to get output from a select to a file ?

ben.brugman (5/13/2016)
sestell1 (5/13/2016)
Interesting question.
I've always used a combination of xp_cmdshell and bcp to move data to/from files within T-SQL.
As said this poses a security 'breach'.
Nah. No security breach. ...
--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 13, 2016 at 11:08 am

#1878980
RE: recursive sp_spaceused query

Wouldn't it all be easier to just use a SELECT from sys.master_files? Do you really need to know things like the amount of free space and how much space...
--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 12, 2016 at 9:13 pm

#1878811
RE: Use Tools

Iwas Bornready (5/11/2016)
Will we lose jobs with the invention of the Cotton Gin? Sure, but there will always be something else.
Yep... weave the cotton and drink the gin. 😛
--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 12, 2016 at 12:07 am

#1878440

Viewing 15 posts - 17,656 through 17,670 (of 59,069 total)