Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,531 through 19,545 (of 59,098 total)

RE: Why Does SHRINKFILE Page Latch on a page in different File?

jheim (9/28/2015)
MY shrink ended after 4hrs.....most of that time the dmvs indicated it was waiting on the same page....too weird.
But the take-aways I have are multiple file objects will require...
--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)

September 28, 2015 at 5:00 pm

#1830029
RE: Backup job & Integrity checks are failing

ramana3327 (9/27/2015)
There is another job scheduled to run the full backup of one db to the network path. It is successful but the backup & Check db jobs which were...
--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)

September 28, 2015 at 4:25 pm

#1830026
RE: No Time for Testing

Steve Jones - SSC Editor (9/28/2015)
Jeff Moden (9/27/2015)
First, I loved your observations in the article. It takes so little time to "test-as-you-go" that I don't understand why more people don'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)

September 28, 2015 at 4:21 pm

#1830025
RE: How to avoid using scalar User Defined Functions?

Ed Wagner (9/28/2015)
Jeff Moden (9/28/2015)
Kim Crosser (9/28/2015)
On the other hand, UDFs used to do some fancy formatting of an output result value aren't likely to have any significant impact 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)

September 28, 2015 at 1:57 pm

#1829996
RE: How to avoid using scalar User Defined Functions?

Kim Crosser (9/28/2015)
On the other hand, UDFs used to do some fancy formatting of an output result value aren't likely to have any significant impact on performance.
Lets not guess... Post...
--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)

September 28, 2015 at 1:39 pm

#1829991
RE: Extract filename from fully qualified path

Anil Kolla (9/28/2015)
SELECT RIGHT([FileName],CHARINDEX('\',REVERSE([FileName]),-1 )) AS NameOfFile
'Zactly.... no expensive double reverse required. One is bad enough. 😀 No length calculation required, either.
--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)

September 28, 2015 at 12:12 pm

#1829971
RE: Continuous slowness from last 2 week

Bill-89778 (9/28/2015)
Hi EB,
I had been in a similar situation shortly ago. In a nutshell, our issue was an inadequate storage array. I would analyze disk performance using iPerf...
--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)

September 28, 2015 at 12:07 pm

#1829970
RE: First date of the Month (to date on Range basis)

Kristen-173977 (9/28/2015)
smer (9/28/2015)
Hi Team,
Help to get the Sql Query e.g when execute on 8/15/2015 get the records from 8/1/2015 to 8/15/2015, if run on 9/20/2015 get 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)

September 28, 2015 at 7:34 am

#1829870
RE: SOmething weird with SQL patching

WhiteLotus (9/21/2015)
Hi all ,
I just did SQL patching ( Service pack 3) to my testing server and it turns out that only SQL browser and writer have been updated but...
--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)

September 28, 2015 at 7:33 am

#1829868
RE: Improve performance of query

raj.prabhu001 (9/28/2015)
Hi guys please guide me how can i improve the performance of the below query by making changes to it.
Select Col1
...
--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)

September 28, 2015 at 7:28 am

#1829864
RE: Issues and performance of importing XML into SQL Server 2008

Sideout1972 (1/31/2012)
TedT,
It ran horribly from the command line as well. After taking steps to eliminate memory issues by putting the code that processes an XML doc into its own...
--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)

September 28, 2015 at 6:02 am

#1829840
RE: President Xi's and President Obama's agreement to curb economic cyberspying.

andrewbb (9/27/2015)
Jeff Moden (9/27/2015)
There are two problems with you're good solutions, IMHO...
1. They're usage is not enforceable.
2. They only address a small part of the problem.
It is 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)

September 27, 2015 at 5:52 pm

#1829774
RE: President Xi's and President Obama's agreement to curb economic cyberspying.

There are two problems with you're good solutions, IMHO...
1. They're usage is not enforceable.
2. They only address a small part of the problem.
--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)

September 27, 2015 at 11:00 am

#1829761
RE: No Time for Testing

From the article:
What I don't get is why we don't just mock up a quick test that we can run in an automated fashion.
First, I loved your observations 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)

September 27, 2015 at 10:48 am

#1829759
RE: Pagination in T-SQL to be done on 50000 records . Display 20 rows at single time

myzus2004 (9/25/2015)
The execution plan is Index seek or clustered index scan almost everywhere
Note that "clustered index scan" is a fancy name for "table scan".
--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)

September 25, 2015 at 5:03 pm

#1829664

Viewing 15 posts - 19,531 through 19,545 (of 59,098 total)