Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,991 through 16,005 (of 59,067 total)

RE: Find Median

Luis Cazares (12/30/2016)
EDIT: In SQL Server 2012, there was a function added that would simplify the queries looking for the median. I didn't include it because this is a 2008...
--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 30, 2016 at 7:38 am

#1920088
RE: Numeric characters that are varchar type going into Excel column as string

southernnevada99 (12/28/2016)
I am exporting data from sql2012 into excel sheet...
HOW are you doing the export and what format are you using? For example, are you using CSV/TSV or what?
--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 30, 2016 at 7:36 am

#1920087
RE: Deadlock Problem on a Heap Table

@lmarkum,
There are a couple of issues that are just wasting a lot of CPU time.
The first is the problem of the store procedure variables that involve dates being setup 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)

December 30, 2016 at 7:33 am

#1920085
RE: Are the posted questions getting worse?

ThomasRushton (12/30/2016)
What is this, a free consultancy?
http://www.sqlservercentral.com/Forums/Topic1846082-2799-2.aspx
Strewth. Where's my popcorn?
No. It's someone with a very appropriate login handle.
--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 30, 2016 at 5:53 am

#1920074
RE: Long running data flow task

Possibly out of date stats on the source? Maybe parameter sniffing? Maybe someone had a long winded transaction on one of the underlying tables of the view?
--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 29, 2016 at 10:55 pm

#1920056
RE: Find Median

Yes. First, see my original post on the subject from 2007 so you get the big picture of what was requested so that you'll understand the following code, which...
--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 29, 2016 at 10:33 pm

#1920055
RE: Extended Events for Tracking Backup and Restore Progress

@pankaj.chakole,
My apologies. I got caught up in the moment because of a different thought process than most. Like I said, I wouldn't use Extended Events for this particular...
--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 28, 2016 at 7:36 pm

#1919951
RE: Application Upgrade and Index Rebuild

chuck.forbes (12/28/2016)
I came across some other suggestions about rebuilding the stats if you are moving to a new version of SQL Server. In this case, we are, from 2008 to...
--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 28, 2016 at 4:51 pm

#1919942
RE: can I query for a list of linked servers?

kevinH-1006814 (7/27/2009)
I have a set of related dbs and I need to do some cross-db queries and I want to do them generically. If I can query for the linked...
--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 28, 2016 at 4:20 pm

#1919937
RE: Deadlock Problem on a Heap Table

lmarkum (12/23/2016)
This problem is occurring on a SQL Server 2012 Standard instance that is on SP1.
There were some really nasty problems in SQL Server 2012 prior to SP3. Things...
--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 28, 2016 at 4:16 pm

#1919936
RE: Issue with column parsing

IIRC, PARSENAME has an element length of NCHAR(128) as a limit on each part it returns and is heavily dependent on the consistent position of items but the following is...
--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 28, 2016 at 4:12 pm

#1919935
RE: Application Upgrade and Index Rebuild

chuck.forbes (12/28/2016)
We're in the midst of an application upgrade, and part of the vendor instructions after the database pieces are upgraded is to rebuild all indexes, for improved performance. I've...
--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 28, 2016 at 4:04 pm

#1919934
RE: Ignore reading signs

peter 67432 (12/28/2016)
I am in need of a way to ignore reading signs, for example:
- I search on (like?) 921996 it will find the record with 92.1996 or 1219!96
Is there...
--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 28, 2016 at 9:45 am

#1919899
RE: Index Fragmentation

Database admin(DBA) (12/28/2016)
Thank you John for your quick reply 🙂 ...Yes checking the fragmentation for all SQL server instances from Monitoring server if fragmentation is more than 30%,i believe...
--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 28, 2016 at 9:43 am

#1919898
RE: The founders

Heh... I sometimes can't remember what I had for dinner last night but I remembered this. Strange how the mind works... or sometimes doesn't.
--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 28, 2016 at 9:22 am

#1919891

Viewing 15 posts - 15,991 through 16,005 (of 59,067 total)