Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,281 through 23,295 (of 59,102 total)

RE: Mysterious deadlocks on a heap table

{EDIT} Please ignore the following. I can't find the article where I saw this and I haven't been able to reproduce it in code. I 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)

July 4, 2014 at 6:49 pm

#1727127
RE: Procedures and functions with cross-database dependencies

I absolutely agree with Lowell but let me give you another hint that will save much in the area of agony in the future....
Don't use anything more than the 2...
--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)

July 4, 2014 at 6:10 pm

#1727125
RE: Poor performance - SQL server 2012 standard edition

Pulivarthi Sasidhar (7/4/2014)
Hello,
We have been facing poor performance while inserting records using MERGE statment in SQL Server 2012 standard edition.
We are using dataloader of salesforce to download the data...
--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)

July 4, 2014 at 5:14 pm

#1727123
RE: BCP error -Unable to open BCP host data-file

tsandeep1407 (3/21/2013)
Hi everyone,
I have this error output in SSMS for the following query
exec Master..xp_cmdshell 'bcp "select blobdata from SynDocs.dbo.BLOBDATA where blobid = 2" queryout "c:\filename2.img" -S ROK-W7STHONUK-7 -T'
The output 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)

July 4, 2014 at 5:06 pm

#1727122
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

my2ndbox (7/4/2014)
Thank you for this article.
I'm very new in SQL-Server field and it was very useful for me, but I have one question which not clear enough for me:
Suppose I...
--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)

July 4, 2014 at 1:07 pm

#1727120
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Personally, I'd much prefer the iTVF (inline Table Valued Function) over the view because it runs as fast as the view and is much easier to control the range of...
--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)

July 4, 2014 at 9:35 am

#1727111
RE: If not exists returning false when should be true

Maddave (7/3/2014)
John Mitchell-245523 (7/3/2014)
An alternative worth considering, since you have a primary key constraint, is to skip the existence check, and instead to handle the error when it occurs.
John
That 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)

July 3, 2014 at 6:25 pm

#1726990
RE: Backups and 3rd party support...now I have a headache.

j.a.c (7/2/2014)
It seems that his boss was having an issue with a piece of software that had SQL Server 2008 [font="Arial Black"]Express[/font] as its data store.
...
{snip}
...
I took a look...
--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)

July 3, 2014 at 4:18 pm

#1726979
RE: Never Stop Learning

Andy Leonard (6/24/2014)
Comments posted to this topic are about the item <A HREF="/articles/Editorial/110058/">Never Stop Learning</A>
Really nice article from one of the best. Thanks Andy.
The problem that I see with...
--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)

July 3, 2014 at 4:01 pm

#1726977
RE: Replace a Cursor

ksrikanth77 (7/3/2014)
Thanks Lynn for the code. It works as expected however the length of the @str Nvarchar(Max) variable is not enough to generate the complete select statement for all 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)

July 3, 2014 at 3:37 pm

#1726972
RE: OPENXML vs XQuery

N_Muller (7/3/2014)
This question pertains to SQL versions 2008 and higher - which provides better performance for parsing/reading a XML data type, OPENXML or XQuery? Are there instances where one 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)

July 3, 2014 at 3:14 pm

#1726969
RE: Interview question :critical issue faced by dba

vsamantha35 (7/3/2014)
Hi Experts,
I need some guidance on this.
Recently I have attended a job interview for sql server database administration and was asked to speak about one of the critical issue...
--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)

July 3, 2014 at 3:10 pm

#1726968
RE: How to get started with freelancing database projects ?

To be honest, I try not to spend too much time trying to scare up work. Contact a couple of reputable recruiters and let them scare up the work...
--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)

July 3, 2014 at 2:40 pm

#1726964
RE: Good practice to separate tables with static data?

ScottPletcher (7/2/2014)
I wouldn't want to put them in a separate schema unless you really had to. Aside from hideous renaming issues (*), you might end up with what seems...
--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)

July 2, 2014 at 9:05 pm

#1726678
RE: Need to add Balance of previous Row to Current Row

Alan.B (7/2/2014)
Sean Lange (7/2/2014)
If you use the quirky update please make sure you read the article carefully. There are a number of extremely important requirements that must be met for...
--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)

July 2, 2014 at 8:08 pm

#1726673

Viewing 15 posts - 23,281 through 23,295 (of 59,102 total)