Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,916 through 15,930 (of 59,063 total)

RE: I'm Having Trouble Parsing This Date Calculation Expression

It has to do with INTEGER MATH.
The number "0" in the integer "date serial number" of the first of January, 1900,
The number 1404 is the number of [font="Arial Black"]whole [/font]month's...
--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 9, 2017 at 8:01 pm

#1921519
RE: Kill Database sessions

It's much easier to just set the database to the single user mode with an immediate rollback.
--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 9, 2017 at 8:43 am

#1921405
RE: The Tally Table

Ed Wagner (1/9/2017)
I've already voted for it as well. As of now, it's 244 to 5.
You just have to wonder what was on the mind of the folks that...
--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 9, 2017 at 6:53 am

#1921341
RE: The Tally Table

Gary Varga (1/9/2017)
I feel a bit deflated as I had already voted for this. I bet it was from an early suggestion from Jeff.
Thanks, Gary. Yes, it was 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 9, 2017 at 6:50 am

#1921340
RE: The Tally Table

I know this is an older thread but MS started making noises like they may add a built in Tally Function. Erland Sommarskog was the driving force there 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)

January 8, 2017 at 8:23 pm

#1921292
RE: Using a variable in CTE Select statement

CELKO (1/7/2017)
I have to write a query that lists orders and partitions them by customer id# and displays the something_date, customer_id, generic_name, order_amount and something_count on each line (sic).
We...
--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 8, 2017 at 10:49 am

#1921268
RE: Need Hep With SQL Login

shravanihnk (1/8/2017)
Please see the attachment
Please read and heed the first link under "Helpful Links" in my signature line below. It'll help you get better answers more quickly especially since...
--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 8, 2017 at 9:58 am

#1921266
RE: Gracefully Handling CLR Function Problems

The 2nd most graceful way to handle these wayward CLRs would be to get someone to write them correctly so that they don't cause the type of problems you're 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 7, 2017 at 5:19 pm

#1921256
RE: get i/o physical read/writes for daterange

Snargables (1/6/2017)
Is there a way to get the i/o stats for say the last 24 hours? I assume not however figured i'd ask.
Perhaps set up Windows Performance monitor to save...
--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 7, 2017 at 5:07 pm

#1921254
RE: Changes are Coming to the SQLServerCentral Forums

Looking forward to what you good folks have done! Here's to a successful deployment!
--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 7, 2017 at 5:04 pm

#1921253
RE: Data loading is incomplete -

ramana3327 (1/7/2017)
Hi,
We have a SQL Job that truncate tables in one database then insert into the tables from different database. Some times we are missing some data with in the...
--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 7, 2017 at 4:08 pm

#1921252
RE: Add loginName...etc on select * from sys.procedures

Tac11 (1/6/2017)
Hi expert,
How to add LoginName, ApplicationName, HostName on select * from sys.procedures to find out who altered the Store procedure. I tried from default trace but not working 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)

January 7, 2017 at 8:20 am

#1921240
RE: The Salary Range

Gary Varga (1/7/2017)
Steve Jones - SSC Editor (1/6/2017)
Gary Varga (1/4/2017)
Just because someone enjoys doing something doesn't mean they are any good at it.
I enjoy singing in my car. When alone....
--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 7, 2017 at 7:50 am

#1921239
RE: The Salary Range

Alan.B (1/3/2017)
Great post Steve, 5 stars.
I found out a few weeks back that my department is moving to Phoenix AZ. I did not chose to transfer so I'll be...
--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 7, 2017 at 7:22 am

#1921238
RE: Long wait times for parallel queries

but, looking at the statistics it was doing a lot of reading but no writing with intermittent PAGEIOLATCH_SH waits before returning to runnable status but never see running.
I don't know...
--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 6, 2017 at 5:17 pm

#1921230

Viewing 15 posts - 15,916 through 15,930 (of 59,063 total)