Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,456 through 22,470 (of 59,102 total)

RE: Best Practices

ramana3327 (11/18/2014)
Hi Jeff,
The report is now taking more than 12 hr.
The report is executing one SP. The SP initially when tested 2 months it took around 10min to execute from...
--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)

November 18, 2014 at 7:24 pm

#1759445
RE: Export to excel row colors

Is it Excel or SSRS doing that? Or, maybe, both?
--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)

November 18, 2014 at 7:06 pm

#1759444
RE: How do you pad left like using T-SQL query?

ScottPletcher (11/18/2014)
If you're padding a numeric value, I'd suggest using the built-in function:
STR()
I suspect that will perform better than writing the same thing out in your own code.
Actually, STR() 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)

November 18, 2014 at 6:47 pm

#1759442
RE: Export to excel row colors

Heh... and people ask me why I use T-SQL to build HTML for my morning reports. We're going through our first setup of SSRS 2012 at work. 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)

November 18, 2014 at 9:00 am

#1759318
RE: Remove Character from specific Column

ahfb (11/18/2014)
Hi Firends
How to remove Character From Column,Just Character.
I want to work with number.
Tnx For Help
Do you mean you want to remove all non-numeric-digits from the column? And, like...
--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)

November 18, 2014 at 8:50 am

#1759313
RE: How do you pad left like using T-SQL query?

Alex Jordan (11/17/2014)
Trying to pad zero's to the left of number to find n.Num LIKE
SELECT * FROM tblNumbers n WHERE n.Num LIKE 'RIGHT('00000' + CONVERT(VARCHAR, CONVERT(INT, '1234')), 5)%' ORDER BY...
--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)

November 17, 2014 at 9:35 pm

#1759148
RE: Monitoring Tool For SQL Server

rajan.nithin (11/17/2014)
Hi,
Can somebody help me by suggesting the best Free Monitoring tool for SQL Server.
How many servers? I ask because it's tough to eyeball more than one server at...
--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)

November 17, 2014 at 9:11 pm

#1759146
RE: System Database Locations: Why?

andre.quitta (11/17/2014)
I had my infrastructure manager recently ask me why the system databases are in a different directory than the user databases.
Contrary to what the others have said and except...
--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)

November 17, 2014 at 8:50 pm

#1759142
RE: SQL Management Studio 2005 _ JOB

artbalauro (11/17/2014)
Hi there,
Just want to ask if theres a way on sql management studio 2005, to create one job for one database having steps and scheds ( daily, weekly, monthly...
--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)

November 17, 2014 at 8:00 pm

#1759139
RE: Joining the results of two queries without creating temporary tables.

MMartin1 (11/17/2014)
dogramone (11/16/2014)
Are you making a stored procedure call here? I'd recommend it and then make the first line "set nocount off" and the last "set noucount 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)

November 17, 2014 at 7:25 pm

#1759136
RE: Are the posted questions getting worse?

spaghettidba (11/17/2014)
Steve, spam deletion in a good thing, but preventing spam is better in my opinion.
I just registered to the site with one of my addresses and it simply asks...
--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)

November 17, 2014 at 11:56 am

#1759059
RE: Where are the DBA's!?

schwizla (11/17/2014)
Hey everyone. Does anyone have any idea roughly how many SQL DBA's there are globally or how they are geographically dispersed? I am thinking that really the only way...
--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)

November 17, 2014 at 7:54 am

#1758992
RE: Passing Integers in my query

Ah, thanks.
I guess I'm going to have to figure out something to make a DelimitedSplit8K that works for things > 8K characters because doing a REPLACE to build the XML...
--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)

November 17, 2014 at 7:09 am

#1758963
RE: Normalizing Performance

I'll also add that I've seen many well intentioned good folks spend a huge wad of money on brand new servers with tons of memory and very high performance SANs,...
--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)

November 16, 2014 at 5:57 pm

#1758858
RE: Joining the results of two queries without creating temporary tables.

thomaswellington (11/16/2014)
I am not calling a stored procedure in my query. (I don't think I can call any stored procedures from the data base.) I just want 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)

November 16, 2014 at 5:36 pm

#1758857

Viewing 15 posts - 22,456 through 22,470 (of 59,102 total)