Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,546 through 16,560 (of 59,067 total)

RE: Procedure Cache Hit Ratio

MVP_enthusiast (10/22/2016)
Eirikur Eiriksson (10/22/2016)
MVP_enthusiast (10/22/2016)
Last night I just migrated one of my busiest databases from SQL 2008 to 2012. Max server memory allocated to SQL Server In 2008 was 50000...
--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)

October 22, 2016 at 9:37 pm

#1908198
RE: Looking for way to dynamically replace street suffix with abbreviation based on tables

jeff.born (10/21/2016)
Drew,
I'm not sure how to write the ISNULL version.. This syntactically incorrect version I came up with is:
SELECT a.Address_pk, a.[Address],
STUFF(a.[Address], ss.search_idx, LEN(ss.search_val), ss.PostalServiceStandardSuffixAbbreviation) AS AddressAbbreviated
FROM [Address] a
OUTER APPLY (
SELECT...
--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)

October 22, 2016 at 8:20 pm

#1908196
RE: Small index blows huge logfile during online index rebuild

You might want to take a look at the design of that table. Things like NVARCHAR(1) or using any type of character based datatype to hold only digits 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)

October 22, 2016 at 6:27 pm

#1908191
RE: The Backup Operator

BWAA-HAAA!! The correct answer isn't actually available on this question. 😉 There is no way that I'd grant a non-DBA the privs to do a direct backup even...
--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)

October 22, 2016 at 4:59 pm

#1908186
RE: Procedure Cache Hit Ratio

Personally, I think that if you have a heavy (read that as "frequent") usage database and it takes more than 5-10 minutes for most everything to settle into cache, then...
--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)

October 22, 2016 at 4:50 pm

#1908185
RE: T-SQL Code Analysis Tools

I think that people spend way too much on cop-like programs like this. SELECT * isn't necessarily a problem (in fact, I've seen it provide a performance improvement on...
--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)

October 22, 2016 at 4:30 pm

#1908184
RE: Are the posted questions getting worse?

Eirikur Eiriksson (10/20/2016)
Gazareth (10/19/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past
😎
First line: "Version 4.2 also lets you nest triggers"
I didn't get any further due to blacking out; came 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)

October 22, 2016 at 1:04 pm

#1908174
RE: JSON Select - Easily query values from JSON

I'm really torn here. I want to give the article 5 stars (especially for a "first" article for the author) for how well it was written and I also...
--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)

October 22, 2016 at 10:17 am

#1908172
RE: Stop query if it is taking too long

mah_j (10/22/2016)
Hello
How can I stop the long running query that is run from application?
I want to kill the queries that are running longer than 40 seconds.
I don't know if you're...
--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)

October 22, 2016 at 8:21 am

#1908169
RE: Can I do this?

BLandry474 (10/20/2016)
Here is my brilliant idea (that I am sure someone else already thought of...)
We have a situation where we regularly get tables from another department and we have 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)

October 21, 2016 at 10:47 pm

#1908150
RE: Groep history table by week

yvesql (10/21/2016)
Hi, suppose i have the following table, is it possible to group the totals by week nr? (from Monday to Sunday)
date/time ...
--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)

October 21, 2016 at 9:43 pm

#1908148
RE: How to get Matrix format query in T-SQL

To explain the ancient but very effective CROSS TAB method that Alan used, please see the following article, which comes complete with a performance test that demonstrates one of 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)

October 21, 2016 at 9:33 pm

#1908147
RE: Looking for way to dynamically replace street suffix with abbreviation based on tables

@jeff.Born,
The list you have looks a bit familiar. Are you, by any chance, using the tables from the USPS? I ask because I went through this very same...
--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)

October 21, 2016 at 9:28 pm

#1908145
RE: Importing - best approach to compare Excel row counts against the table created

Just to be sure, ol' friend... please don't ever take my sometimes (usually?) zealous contrarian attitude towards SSIS personally. Without boring you with the ugly details, I 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)

October 21, 2016 at 6:03 pm

#1908138
RE: Importing - best approach to compare Excel row counts against the table created

Phil Parkin (10/21/2016)
Jeff Moden (10/21/2016)
Phil Parkin (10/20/2016)
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
First point to note is that a CSV file is a far far better thing 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)

October 21, 2016 at 8:14 am

#1907973

Viewing 15 posts - 16,546 through 16,560 (of 59,067 total)