Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,456 through 13,470 (of 59,095 total)

RE: adding 365 partitions to existing scheme and fucntion in sql server 2014

prem.m38 - Monday, December 11, 2017 2:25 AM
Jeff Moden - Sunday, December 10, 2017 2:44 PM
--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)

December 11, 2017 at 6:44 am

#1971533
RE: Delayed gratification or not?

"Delayed Gratification" and "Patience" have a whole lot to do with each other and I've benefitted from both in many ways, especially on the job.
We recently had 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)

December 11, 2017 at 6:25 am

#1971525
RE: SQL Agent Time Gap between job steps

Could it be simple blocking of table resources since more than one job is running?
--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)

December 10, 2017 at 11:38 pm

#1971499
RE: How to execute multiple scripts

RTaylor2208 - Thursday, December 7, 2017 5:06 AM
One easy and free solution is to use a parameterised batch file (there are more...
--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)

December 10, 2017 at 11:27 pm

#1971498
RE: Which OS for SQL Server 2017 Standard? (new data warehouse)

Rekonn - Thursday, December 7, 2017 8:43 AM
My company will be setting up a new data warehouse server using SQL Server 2017...
--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)

December 10, 2017 at 10:34 pm

#1971495
RE: Calculating varying process capacity

I'm with Steve. I love "Helper Tables" because you can change their content instead of changing code. If it were my task, here's the table that I'd build.
--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)

December 10, 2017 at 10:10 pm

#1971494
RE: Find and count Incomplete records in a table

p.s. Here's hoping that you really are using SQL Server 2014. IIF came out with 2012 and it resolves to CASE operators behind the scenes but it sure does simplify...
--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)

December 10, 2017 at 8:12 pm

#1971492
RE: Find and count Incomplete records in a table

Shifting gears and perhaps I'm over-anticipating/over-engineering , but it looks a bit like someone is trying to do a workload analysis. If that's the case, let's look into a bit...
--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)

December 10, 2017 at 8:04 pm

#1971491
RE: Find and count Incomplete records in a table

eyejay - Thursday, December 7, 2017 12:43 PM
Steve,
Thank you, thank you, thank you!
That's just perfect and absolutely what I needed 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)

December 10, 2017 at 6:09 pm

#1971489
RE: Help with Trigger emial

Sue_H - Thursday, December 7, 2017 4:08 PM
pietlinden - Thursday, December 7, 2017 3:32 PM
--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)

December 10, 2017 at 5:31 pm

#1971488
RE: Linked Server Error

Balz - Friday, December 8, 2017 12:48 AM
Hi,
I am trying to export the SQL (Server 2012) data to Excel file. 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)

December 10, 2017 at 4:55 pm

#1971487
RE: Scripting Tables with ALTER with dependencies

Arsh - Saturday, December 9, 2017 4:25 AM
Dear Experts,
Please advise how I can script all the tables of a database with ALTER...
--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)

December 10, 2017 at 4:19 pm

#1971486
RE: "Tag" highest value in the month

Simple SQL Tips - Sunday, December 10, 2017 12:51 AM
First of all, thank you for the assistance. After running the code 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)

December 10, 2017 at 3:38 pm

#1971485
RE: adding 365 partitions to existing scheme and fucntion in sql server 2014

prem.m38 - Sunday, December 10, 2017 2:35 AM
Hi
My tables are partitioned on business date. My requirement is to add 365 partitions for...
--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)

December 10, 2017 at 2:44 pm

#1971484
RE: STRING_SPLIT with no delimiter

Awesome thinking outside the box! Well done!
--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)

December 10, 2017 at 2:38 pm

#1971483

Viewing 15 posts - 13,456 through 13,470 (of 59,095 total)