Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,501 through 19,515 (of 59,072 total)

RE: How do I generate test data using only VS 2013?

Start here...
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
--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 29, 2015 at 4:08 pm

#1830295
RE: A Case for Database CI

dg81328 (9/27/2015)
Time after time I have been called only when problems bubbled up to management who made the decision to call-in an experienced person to diagnose "the database problem".
The problem'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)

September 29, 2015 at 4:06 pm

#1830294
RE: Temp Table's Primary Key Default

Ostensibly, the Temp Table has only the required data in it and every row will be used/updated in some fashion. Try NOT having any indexes on the Temp Table...
--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 29, 2015 at 8:07 am

#1830157
RE: Continuous slowness from last 2 week

EasyBoy (9/28/2015)
Yes. User facing the slowness at specific time. They claim that switching tabs takes about 2-3 minutes or when they enter patient information to the application.
Sorry... my comment was...
--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:21 pm

#1830030
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

Viewing 15 posts - 19,501 through 19,515 (of 59,072 total)