Jeff Moden

Forum Replies Created

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

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
RE: Table Designing

Lempster (7/2/2014)
Bill Talada (7/2/2014)
Set your own standards and stick to them....
I agree with that! Everything else (trying to promote your standards over others) just opens up a can of worms...
--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 10:53 am

#1726577
RE: Need help with employee hierrarchy

sunitkrishna (7/2/2014)
Hi,
I need help with the following query:
----------------------------------------------------------------------------------------------
declare @LoginId nvarchar(20)
set @LoginId='A-1519'
declare @LoginName nvarchar(100)
set @LoginName=(select [FirstName] + ISNULL(''+[MiddleName],'') + ISNULL(''+[LastName],'')
from [dbo].[Employee] where EmpId=@LoginId)
;WITH EmployeeTree(EmpId,FullName,DesignationName,ReportingMgr,LoginMgr)--,TreeLevel)
AS (
SELECT EmpId,[FirstName] +...
--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 10:41 am

#1726572
RE: How to repair backup of .mdf file database?

jasonkabe22 (7/1/2014)
Data from corrupt mdf file can be recovered by following methods:
Repair MDF file with DBCC CHECKDB: Microsoft offers a command that is known as DBCC CHECKDB, when you run...
--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 1, 2014 at 11:00 pm

#1726376

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