Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,091 through 18,105 (of 59,069 total)

RE: Numeric or Decimal Data Type in SQL 2012?

bsmith 63193 (3/16/2016)
Thank you for the replies. Would it be recommended to use decimal over numeric because it is a wider held standard?
The really cool part about standards is... there...
--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)

March 16, 2016 at 7:35 pm

#1865773
RE: Copy image from one folder to another with sql server except duplicate image

RV16 (3/16/2016)
The best way to copy student image is using robocopy instead of sql server scripts
So I just used that way:
And now its solved. So I just put answer anyone...
--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)

March 16, 2016 at 6:36 pm

#1865767
RE: Change t-sql 2012 to not use a cte

Sergiy (3/16/2016)
Do not turn birthday to ages, turn predefined ages into date ranges for birthdays:
Best idea I've heard in a month.
--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)

March 16, 2016 at 6:33 pm

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

mister.magoo (3/16/2016)
Jeff Moden (3/16/2016)
So, what would you prefer to see with the following (using a cte as if a Table Source)...
WITH cteTestData (RowNum,CSV) AS
(
SELECT 1, '1,2,3' UNION ALL
SELECT...
--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)

March 16, 2016 at 6:31 pm

#1865765
RE: Numeric or Decimal Data Type in SQL 2012?

bsmith 63193 (3/16/2016)
Is there a preferred recommendation by database administrators of whether to use Decimal or Numeric data types for values that will have decimal values?
It's been my experience that...
--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)

March 16, 2016 at 4:56 pm

#1865755
RE: Change t-sql 2012 to not use a cte

wendy elizabeth (3/16/2016)
I would like to change the following t-sql 2012 from a cte to sql that does not need a cte. I would like to change the t-sql 2012...
--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)

March 16, 2016 at 4:49 pm

#1865753
RE: Memory recommendation

sunny.tjk (3/16/2016)
Grant Fritchey (3/15/2016)
What the other people have said...
CXPacket is only a concern if you also see other CPU waits. The one thing I will say, sight unseen, if your...
--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)

March 16, 2016 at 4:45 pm

#1865752
RE: Are the posted questions getting worse?

Solomon Rutzky (3/16/2016)
Jeff Moden (3/15/2016)
jasona.work (3/15/2016)
Reading the SQL2016 release notes, and especially Jeffs' comments here[/url], I'm wondering if maybe MS didn't bother to set up their string splitter with 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)

March 16, 2016 at 3:38 pm

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

mister.magoo (3/16/2016)
If this new 2016 splitter does get changed to return an ordinal position, (which I hope it does), then I would have to say that returning an empty set...
--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)

March 16, 2016 at 3:13 pm

#1865740
RE: logical and physical file names of all databases

lesemv (3/16/2016)
I'm embarrassed to say. I had the same 'Name' value for the data and log file.
Heh... thanks. I'm sure that none of us have ever done that...
--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)

March 16, 2016 at 7:26 am

#1865591
RE: You'd like to load lots of historical data...

Eric M Russell (3/15/2016)
.. You wish to temporarily disable all foreign key constraints on the table since this is an archive database and you orphaned records are acceptable 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)

March 15, 2016 at 11:28 pm

#1865512
RE: Operand type clash: date is incompatible with int

You could also change this...
DECLARE @TheDate DATE
... to this ...
DECLARE @TheDate DATETIME
... and continue to do the -1 trick.
Heh... now duck... here come the DATE/TIME police whose hair just burst...
--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)

March 15, 2016 at 11:23 pm

#1865511
RE: logical and physical file names of all databases

lesemv (3/15/2016)
nevermind
What did you find to make you say "nevermind"?
--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)

March 15, 2016 at 11:17 pm

#1865509
RE: Count of records in all tables, specify DB

Jeffery Williams (3/15/2016)
That is a great suggestion. In those case it wont work because I am having to link server call everything and their are many databases across multiple servers....
--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)

March 15, 2016 at 11:08 pm

#1865508
RE: Question about disk space report

dany.fortier (3/15/2016)
I will try DBCC checkdb if it found error and then i will ran DBCC updateusage
Will let you know if this was the solution
The DBCC UPDATEUSAGE will do 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)

March 15, 2016 at 11:05 pm

#1865507

Viewing 15 posts - 18,091 through 18,105 (of 59,069 total)