Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,406 through 21,420 (of 59,098 total)

RE: Why does backup cause trigger to fire?

I'll never understand why people audit the INSERTED table, ever. It's a gross duplication of data.
--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)

March 2, 2015 at 2:09 pm

#1781215
RE: Need help to create file with name and current time stamp.

Note that BCP can generate files with the .xlsx extension, but they'll still just be text files. BCP cannot generate a true spreadsheet file... period. At best, 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)

March 2, 2015 at 1:46 pm

#1781205
RE: Patitioning

iqbalbutt (3/2/2015)
Is this the correct process to do partitioning?
Rename constraints, indexes, and table
Create table
Create clustered index using Partition Scheme
Create constraints
Back fill data from renamed table
Create non clustered indexes
Verify row counts
Drop...
--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)

March 2, 2015 at 12:23 pm

#1781192
RE: Partitioning

iqbalbutt (3/2/2015)
Is it a good practice to ask your manager for downtime before implementing partition?
You should keep this question with the questions you asked about downtime on partitioning where 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)

March 2, 2015 at 12:21 pm

#1781191
RE: EXCEL HELL!!!

sqldriver (3/2/2015)
This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀
😀
--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)

March 2, 2015 at 9:33 am

#1781142
RE: Patitioning

sql-lover (3/2/2015)
iqbalbutt (3/1/2015)
When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs...
--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)

March 2, 2015 at 9:05 am

#1781130
RE: Are the posted questions getting worse?

Lynn Pettis (3/1/2015)
I am HOME!
I had a nice dinner at Kassondra's house. I'm sorry, nothing beats good home cooking!
Yeeee-haaaa!!!! The disturbance in the force has been resolved! ...
--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)

March 2, 2015 at 9:00 am

#1781128
RE: Flip data in SQL

helal.mobasher 13209 (3/1/2015)
Jeff,
Thank you very much for your help. Just curious to know how to make it as dynamic SQL?
Helal
Luis' code (above) will do the dynamic thing for you.
--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)

March 2, 2015 at 8:56 am

#1781125
RE: Insert into table dates in between two dates

cs_source (2/28/2015)
I have a table that has hotel guests and their start stay date and end stay date, i would like to insert into a new table the original information...
--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)

March 1, 2015 at 9:40 pm

#1781018
RE: Patitioning

iqbalbutt (3/1/2015)
When you load the data into a new partition table, can it to done online without any downtime? because I have few tables that are around 250 gigs 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)

March 1, 2015 at 9:35 pm

#1781017
RE: Creating Tables from Excel list

GrassHopper (3/1/2015)
I have a list in Excel that has a list of about 30 tables with all column names and types. How can I programatically create the tables using...
--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)

March 1, 2015 at 9:32 pm

#1781015
RE: Flip data in SQL

This does it and could be fairly easily converted to dynamic SQL if you needed it to be.
SELECT t1.ID, t1.Name, ca.YrMnth, ca.Enrollment
FROM #Table1 t1
CROSS...
--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)

March 1, 2015 at 9:13 pm

#1781013
RE: what to do when we see multiple blocking chains?

vsamantha35 (2/28/2015)
Hi All,
How to troubleshoot blocking if u r seeing multiple blocking chains? Do I need to kill all the head blockers?
What is the best approach to deal 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)

March 1, 2015 at 5:11 pm

#1781004
RE: Need to export one table to another database in a different server/db

sql-lover (3/1/2015)
But in my experience , import and export wizard is as fast as bcp. Like I said, I've copied billion records this way and tested with bcp 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)

March 1, 2015 at 5:07 pm

#1781003
RE: Need to export one table to another database in a different server/db

Michael L John (3/1/2015)
Of course, assuming you have a LinkedServer already in place.
You do not need to have a linked server to use the import / export wizard.
And, for 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)

March 1, 2015 at 5:04 pm

#1781002

Viewing 15 posts - 21,406 through 21,420 (of 59,098 total)