Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,526 through 18,540 (of 59,072 total)

RE: Today's Random Word!

TomThomson (1/22/2016)
SQLRNNR (1/22/2016)
Ed Wagner (1/22/2016)
SQLRNNR (1/22/2016)
DonlSimpson (1/22/2016)
SQLRNNR (1/22/2016)
runt
squirt
herder
Sheep
Black
Coal
Graphene
--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)

January 22, 2016 at 7:06 pm

#1853961
RE: Sub-Grouping by consecutive rows

mishka-723908 (1/22/2016)
Hello, Thank you for the reply. It did work. This is the way I get the data in the file from a source system and need to properly insert...
--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)

January 22, 2016 at 6:56 pm

#1853960
RE: Sub-Grouping by consecutive rows

Jason A. Long (1/22/2016)
I think this what you're after... Please note that this much easier on later editions of SQL server using the LAG/LEAD functions...
Some consumable test data...
IF OBJECT_ID('tempdb..#temp', 'U')...
--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)

January 22, 2016 at 6:48 pm

#1853957
RE: Sub-Grouping by consecutive rows

mishka-723908 (1/22/2016)
Hello, Thanks for your reply.
This will group all the rows where A = 1 and B = Al to one row.
I only want to sum those up where...
--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)

January 22, 2016 at 6:46 pm

#1853956
RE: SQL Server 2008 - DB troubleshooting - need peer review

electrostep (1/22/2016)
Thank you for answering! Could you please confirm what the 'server-side trace' is?
Thank you,
My recommendation would be to not even worry about SQL Profiler to start with. ...
--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)

January 22, 2016 at 6:13 pm

#1853950
RE: Sub-Grouping by consecutive rows

I've not tested it (no readily consumable data in post... see first link in my signature line for how to do that and I strongly recommend you do that before...
--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)

January 22, 2016 at 5:37 pm

#1853946
RE: Flag Values Based on Columns

Eirikur Eiriksson (1/22/2016)
The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups in sequences. Now with...
--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)

January 22, 2016 at 2:31 pm

#1853927
RE: Flag Values Based on Columns

Sergiy (1/21/2016)
Jeff Moden (1/21/2016)
nm.rajesh (1/17/2016)
Thanks a lot 🙂
See my post above. Unless the guarantees that I stated above are enforced by constraints and then the a_m column is brought...
--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)

January 22, 2016 at 2:23 pm

#1853926
RE: Bulk Insert a file from FTP to SQL Server

murthyvs (1/22/2016)
Hi Jeff - "W" is a FTP folder mounted as drive using a program called Webdrive. Thanks
SQL Server can't see that. You need to use the full UNC...
--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)

January 22, 2016 at 2:13 pm

#1853925
RE: See the size of tables using t-sql

river1 (1/20/2016)
Hi,
I have a list of tables (several tables) and I would like to know their size.
Is there a way to know that using t-sql?
It will be easyer then having...
--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)

January 22, 2016 at 2:03 pm

#1853923
RE: Trying to find the percentage of on time shipments

yb751 (1/22/2016)
Providing sample data would have gone a long way for your cause.
Remember that most people don't know that the best way to do that is to create a test...
--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)

January 22, 2016 at 1:47 pm

#1853920
RE: House Keeping - Statistics

NicHopper (1/22/2016)
Hi,
Thank you both for your response, I think I'm going to go with a straight forward SAMPLE by default and let SQL decide based on the table size, but...
--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)

January 22, 2016 at 1:42 pm

#1853919
RE: Bulk Insert a file from FTP to SQL Server

murthyvs (1/22/2016)
Hi all,
My end objective is to load a file that is on FTP server into SQL Server using T-SQL commands.
Situation:
- SQL Server is in data center
- Using 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)

January 22, 2016 at 1:38 pm

#1853918
RE: How to pass parameter values to SQL query

boettger.andreas (1/21/2016)
Yes, @CutOffDate is in the format 'YYYYMM'
Past12Months is a view.
SELECTLEFT(CAST(CONVERT(varchar(8), DATEADD(MONTH, number, LEFT(CAST(CONVERT(varchar(8), DATEADD(MONTH, - 11, GETDATE()), 112) AS INT), 6) + '01'), 112) AS INT), 6) AS YearMonth,...
--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)

January 22, 2016 at 6:36 am

#1853774
RE: Un-partition and decompress tables

Roust_m (1/20/2016)
Hi,
I am planning to un-partition and decompress some large tables to be able to use standard edition of SQL Server.
Given that not clustered indexes get rebuilt when a clustered...
--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)

January 21, 2016 at 7:00 pm

#1853686

Viewing 15 posts - 18,526 through 18,540 (of 59,072 total)