Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,416 through 23,430 (of 59,099 total)

RE: Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

Eirikur Eiriksson (6/15/2014)
Didn't see Lynn's code before I wrote the example, almost the same but without a string thingy
😎
/*Converting INT date and time to datetime */
DECLARE @INT_YYYYMMDD INT = 20140704;
DECLARE...
--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 15, 2014 at 9:55 am

#1721794
RE: Concatenate variable values in the third variable in sqlcmd

Based on what Eirikur posted above, why not build a stored procedure that does this work and execute the stored procedure from SQLCmd, instead?
Also, why are you using SQLCmd? ...
--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 15, 2014 at 9:35 am

#1721793
RE: Queries running slower in SQL 2008 than in SQL 2000

RazvanS (6/15/2014)
Our 2000 server was upgraded to 2008. There is a certain step in a DTS now SSIS package that updates a table, setting parents for child records, that used...
--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 15, 2014 at 9:29 am

#1721792
RE: Counting the characters in a string before a space

cbrammer1219 (6/14/2014)
Tell me about it I have told them before any projects are started the data needs cleaned up, these tables don't even have Pk or fk, they b...
--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 14, 2014 at 2:07 pm

#1721766
RE: Counting the characters in a string before a space

Ok... first of all, I made no real attempt to figure out what the names of the fields are. Somewhere, someone has a RECORD LAYOUT of what the actual...
--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 14, 2014 at 1:46 pm

#1721763
RE: Counting the characters in a string before a space

Luis Cazares (6/12/2014)
cbrammer1219 (6/12/2014)
No I figured I would get the tsql working first, and then attempt that change.
If you fix the data import, you don't need to work that hard...
--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 14, 2014 at 7:17 am

#1721745
RE: Trying to find a more simplistic way to execute this complicated Aggregation Query

BTW... in anticipation of you using any form of partitioning of one month per file per filegroup, if you think it was easy, you probably did it wrong and wasted...
--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 14, 2014 at 6:32 am

#1721741
RE: Trying to find a more simplistic way to execute this complicated Aggregation Query

@Shannon,
The code that you have is fine for what you have. There is no filter criteria in the code so it's going to do a full table scan, no...
--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 14, 2014 at 6:29 am

#1721740
RE: View read only acess

jamessdba (6/13/2014)
Hi,
I have 10 views in our Develoment DB server
How to provide only 2 View and read only Access for the login & users
GRANT.
--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 13, 2014 at 5:15 pm

#1721685
RE: Backup and XP_CMDSHELL move .bak files

Jake Shelton (6/12/2014)
Hi all,
I'm looking for the most time-efficient way to backup db's to a local drive and then move the .bak files across to a new server, as well...
--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 13, 2014 at 5:07 pm

#1721683
RE: Backup and XP_CMDSHELL move .bak files

Eirikur Eiriksson (6/12/2014)
Quick thought, wouldn't it be simpler to have an SSIS package for shuffling the backup files around, no need for XP_CMDSHELL etc.
😎
Since you brought it up, lets see...
--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 13, 2014 at 5:06 pm

#1721682
RE: Splitting a single column into multiple rows

Sean Lange (6/13/2014)
While I agree that the DelimitedSplit8K function is likely to be of help here I want to point out that the datatype containing the csv data is varchar(max)...
--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 13, 2014 at 5:04 pm

#1721681
RE: Query

ramana3327 (6/13/2014)
I saw only records from one query result set and I thought it is giving all together 3 queries result set. Sorry for my mistake. It is giving same...
--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 13, 2014 at 5:01 pm

#1721679
RE: Database Size is shwoing Much larger then Actual Data

logicinside22 (6/12/2014)
whet he is saying is that data space as well as index space grew by 500% when the actual record count grew by 15%
This sounds like page and...
--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 13, 2014 at 4:58 pm

#1721678
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

ColdCoffee (6/13/2014)
Do we have a readymade 10 million/1million row generator for this problem?
Heh... apparently, you didn't read the article where is says... 😉
The code above isn't adequate for performance testing....
--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 13, 2014 at 4:51 pm

#1721676

Viewing 15 posts - 23,416 through 23,430 (of 59,099 total)