Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,836 through 11,850 (of 59,095 total)

RE: Need Help to convert DATETIME result into DATE on SQL Server

jcelko212 32090 - Monday, July 16, 2018 2:29 PM
1753 is the year when the Gregorian calendar started. Today, we use the Common...
--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)

July 16, 2018 at 3:58 pm

#1997752
RE: How would I go about this ...checking if data exists in a table

gothaimviii - Monday, July 16, 2018 10:14 AM
I think I see what is going on. The table I am comparing to does...
--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)

July 16, 2018 at 3:51 pm

#1997750
RE: Flat File csv with double quotes

Interesting. Every time I see something like this, the more happy I am that I don't use SSIS ;-). A BCP FORMAT FILE and the use of BULK INSERT would...
--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)

July 16, 2018 at 3:49 pm

#1997749
RE: 5TB Database and Only a Primary Filegroup

Thanks for the feedback. I also meant to say that, contrary to what many people think/claim, partitioning usually results in somewhat slower query performance than when a good query plays...
--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)

July 16, 2018 at 3:33 pm

#1997747
RE: Generating Completely Random Sample Output from a Dataset

julian.fletcher - Monday, July 16, 2018 8:43 AM
The "it" was the suggested solution:
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)

July 16, 2018 at 2:19 pm

#1997737
RE: Need Help to convert DATETIME result into DATE on SQL Server

sgmunson - Monday, July 16, 2018 7:10 AM
Jeff Moden - Friday, July 13, 2018 9:45 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)

July 16, 2018 at 1:59 pm

#1997731
RE: how can i get the top 3, after i count the column ?

Or possibly using RANK.
--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)

July 16, 2018 at 9:02 am

#1997690
RE: 5TB Database and Only a Primary Filegroup

alex.sqldba - Monday, July 16, 2018 4:44 AM
I want to seperate documents into their file group for backup purposes... We are also...
--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)

July 16, 2018 at 8:59 am

#1997688
RE: dbo.SORT temporary run storage error during DBCC CHECKDB

sgmunson - Monday, July 16, 2018 6:34 AM
With that machine NOT in production yet, pull it's network cable and work directly from...
--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)

July 16, 2018 at 8:26 am

#1997681
RE: Generating Completely Random Sample Output from a Dataset

julian.fletcher - Monday, July 16, 2018 4:30 AM
Interesting, because I had thought that any function that took no parameters or 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)

July 16, 2018 at 8:22 am

#1997680
RE: DBCC FREEPROCCACHE

Steve Jones - SSC Editor - Monday, July 16, 2018 7:36 AM
Often you wouldn't want to free all the plans in 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)

July 16, 2018 at 8:14 am

#1997676
RE: The Age of Multiple Databases

David.Poole - Monday, July 16, 2018 1:59 AM
I saw an interesting article calling SQL a narrow waist. Yes we have all these...
--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)

July 16, 2018 at 7:49 am

#1997668
RE: The Age of Multiple Databases

roger.plowman - Monday, July 16, 2018 7:01 AM
By the way, the 3 stages of tech are: 1) do it at all, 2)...
--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)

July 16, 2018 at 7:47 am

#1997667
RE: The Age of Multiple Databases

xsevensinzx - Sunday, July 15, 2018 8:35 PM
Honestly, it's not just about the size of the data I've found with these systems....
--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)

July 16, 2018 at 7:43 am

#1997664
RE: Repeat union all according to an input parameter

joujousagem2006 1602 - Sunday, July 15, 2018 8:23 AM
Hello
For calculation purposes I need to make a request of type uinon all according...
--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)

July 15, 2018 at 8:32 pm

#1997626

Viewing 15 posts - 11,836 through 11,850 (of 59,095 total)