Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,556 through 18,570 (of 59,098 total)

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
RE: Flag Values Based on Columns

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 into play as...
--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 6:49 pm

#1853682
RE: Flag Values Based on Columns

Hugo Kornelis (1/21/2016)
Hey, here's another idea.
Instead of bashing people who at least attempted to help the OP, why don't you chime in with your solution to the problem? For me,...
--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 6:19 pm

#1853681
RE: Help with an insert script

Hugo Kornelis (1/20/2016)
@dandrews: For future reference, what J Livingstone posted is a good repro script - CREATE TABLE and INSERT statements that people can simply copy/paste into SSMS and run...
--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 5:37 pm

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

boettger.andreas (1/21/2016)
Thanks. I've got it now with iTVF and CROSS APPLY
Great. Can we see your code, please? A whole lot of people end up writing mTVFs instead of...
--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 4:32 pm

#1853676

Viewing 15 posts - 18,556 through 18,570 (of 59,098 total)