Jeff Moden

Forum Replies Created

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

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

Folks are still forgetting about "ties". If you have a dozen ties for 1st, 2nd, or 3rd, is it actually appropriate to ignore such ties or should (must) they be...
--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 17, 2018 at 6:12 am

#1997792
RE: The Age of Multiple Databases

xsevensinzx - Monday, July 16, 2018 6:28 PM
Nope, I mean I am NOT JUST using SQL Server to solve everything. I'm...
--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:27 pm

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

BONITO - Monday, July 16, 2018 8:00 PM
I got it , thanks for all the reply,
i review my code again and it...
--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 pm

#1997762
RE: The Age of Multiple Databases

Rod at work - Monday, July 16, 2018 8:41 AM
Challenging article, Steve. For almost 2 decades I've worked with only relational databases,...
--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 4:47 pm

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

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