Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,296 through 20,310 (of 59,098 total)

RE: Partition an existing SQL Server Table

Welsh Corgi (6/22/2015)
DBA From The Cold (6/22/2015)
You'd need to create the required partition schemes/functions and then rebuild your tables' clustered index onto the partition scheme.
Depending on how your table 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)

June 22, 2015 at 12:06 pm

#1807140
RE: How to subtract dates from previous date on same patient?

NineIron (6/22/2015)
Thanx. This will work out fine.
Possibly not. There is absolutely nothing in your data that will prevent a missing sequence number due to a rollback or other cause.
--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 22, 2015 at 12:03 pm

#1807138
RE: Are the posted questions getting worse?

Ed Wagner (6/22/2015)
Lynn Pettis (6/19/2015)
Sean Lange (6/19/2015)
ChrisM@Work (6/19/2015)
Sean Lange (6/19/2015)
Anybody have the mind reading apparatus? I have misplaced mine and could use it over here. http://www.sqlservercentral.com/Forums/Topic1696091-2799-1.aspx
I'm with Alvin on 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)

June 22, 2015 at 7:26 am

#1807027
RE: Another Rows to Columns question

Luis Cazares (6/16/2015)
Just remember that there's no order inside a table. There's an order inside a flat file, but there's no certainty that SQL Server will load it in 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 21, 2015 at 5:23 pm

#1806922
RE: Another Rows to Columns question

Douglas Osborne-229812 (6/17/2015)
Luis,
That was exactly what I needed. Once I completed the second SQL - I was good to go. I guess when I had tried that technique myself I...
--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 21, 2015 at 5:18 pm

#1806921
RE: No of Months between two dates in YYYYMM format

sqlinterset (6/15/2015)
I am looking to calculate no of months between two dates which are in YYYYMM format.
Like no of months between 201505 and 201305
I know the question has been answered...
--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 21, 2015 at 5:13 pm

#1806920
RE: Trying to use T-SQL to calculate elapsed time

For those that are interested and why I hate what they've done to the newer date and time datatypes (namely making "Direct Date Math" impossible), the maximum number of milliseconds...
--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 21, 2015 at 4:44 pm

#1806919
RE: Trying to use T-SQL to calculate elapsed time

Luis' code will work mighty fine, in most cases. However, if it comes across a span of time that's just a little too big to be handled at 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 21, 2015 at 4:18 pm

#1806918
RE: Error using "Update" and "Set" commands

Hi Sandy,
Here's how I would write the UPDATE statement if it were me.
UPDATE ws
SET ws.wrks_submitted = 'Y'
FROM dbo.employee e
JOIN...
--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 21, 2015 at 3:46 pm

#1806917
RE: Repair Corrupt Access Database File

I know the original post here is quite old but it still bears saying...
REMEMBER... all these wonderful tools may help you recover the bulk of the data and successful load...
--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 21, 2015 at 10:18 am

#1806905
RE: Writing to Excel After Skipping Rows

Editing EXCEL spreadsheets via SSIS or any other method is so wrong for so many reasons. One of the worst reasons is that if someone has the spreadsheet open,...
--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 21, 2015 at 10:14 am

#1806904
RE: Audit administrative logins

Virtually anything and everything that can be done on SQL Server can be undone or sidestepped by anyone having or breaking into the server with sysadmin privs on SQL Server.
I...
--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 21, 2015 at 10:02 am

#1806903
RE: Error using "Update" and "Set" commands

Sandy,
There's a ton of danger in joined updates unless things are done just right and I see a couple of possible "newbie" problems in your examples. Some of 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)

June 21, 2015 at 9:47 am

#1806902
RE: Help in query

Sean Lange (6/19/2015)
Storing integers as floats is crazy. :w00t:
BWAA-HAA!!!! Storing date info in INTs is almost as crazy! 😀
--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 19, 2015 at 9:37 am

#1806744
RE: Need Ammunition for Developers Doing Select *'s

Michael L John (6/19/2015)
The unfortunate part is that it's sometimes very difficult to get the crowd to see the importance of doing it "right" and what "right" means. If...
--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 19, 2015 at 9:15 am

#1806733

Viewing 15 posts - 20,296 through 20,310 (of 59,098 total)