Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,871 through 27,885 (of 59,101 total)

RE: Difference between varchar(max) and varchar(8000)

chetan.aegis (12/14/2012)
sql server 2005 annot exceed 8000 bytes in size.variable binary column can store 8000 bytes assuming in a table.And were as var char can store 2 bytes per Unicode...
--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)

December 14, 2012 at 6:51 am

#1568674
RE: Hierarchy: Check Constraint to Prevent Child->Parent and Parent->Child

Thanks for the feedback, Tom.
--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)

December 14, 2012 at 6:30 am

#1568667
RE: Restrict insert or update when taking backup

GilaMonster (12/13/2012)
rajkiran.panchagiri (12/13/2012)
Is there any other way other than this?
Not really. Setting the DB to read only or single user for the duration of the backup is the simplest. 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)

December 13, 2012 at 8:41 pm

#1568542
RE: Best Way to avoid duplicate rows insertion

saravanakumar-485245 (12/13/2012)
But I dont want to delete the records after insertion. Instead I want to skip the duplicate rows while inserting large number of rows.
You could change your PK 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)

December 13, 2012 at 8:28 pm

#1568541
RE: Performance using CTE vs temp tables

nidhis (12/13/2012)
Hi All,
I have replaced 3 temp tables in my batch with multiple CTEs.
I see remarkable 50% benefit in REads and Writes have reduced to 0, however, I wanted 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)

December 13, 2012 at 8:23 pm

#1568540
RE: Request

Sean Pearce (12/13/2012)
I hope I am not being too cheeky posting this here, but I would appreciate some page views on my article.
The article is about page deallocations on heaps...
--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)

December 13, 2012 at 8:21 pm

#1568539
RE: CHKDSK on a SAN Volume

NMHDBA (12/13/2012)
I know that this topic is a bit old, but I have a very similar question.
Every two weeks we perform server/database maintenance; altering indexes, Windows updates and a server...
--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)

December 13, 2012 at 8:11 pm

#1568538
RE: Accessing data returned from a table valued function

popq79 34287 (12/13/2012)
Hi All,
Is there a way to access values return from a table-valued function?
Sample code:
CREATE FUNCTION [dbo].[fn_MyFunction]
(@ID INT)
RETURNS @return_table TABLE
(Col1 int NULL,
Col2 int...
--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)

December 13, 2012 at 7:52 pm

#1568537
RE: exec master.dbo.xp_cmdshell

Shifting gears, jobs can be executed as "SA". Why do you have a user capable of running xp_CmdShell.
--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)

December 13, 2012 at 7:47 pm

#1568536
RE: exec master.dbo.xp_cmdshell

LOOKUP_BI-756009 (12/13/2012)
:ermm: Its been working all this while but for some reason it has stopped working for only 1 of our environment.
Even executing exec master.dbo.xp_cmdshell 'dir c:\*.txt' brings following...
--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)

December 13, 2012 at 7:46 pm

#1568535
RE: Is it possible to look for a word in the Database ?

SQL SERVER ROOKIE (12/13/2012)
Hi Sean,
I have been told that table A and B are related (2 columns from table A have to be concatenated to form 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)

December 13, 2012 at 7:25 pm

#1568534
RE: Temporarily stop and then restart jobs between Sat 9 pm and Sun 2 am

ZenDada (12/13/2012)
I got partial answers from @sqldba and @SQLfool on #SQLhelp. Can hack my way from there. So NM.
Cool! Can you share the solution, please? Thanks.
--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)

December 13, 2012 at 7:22 pm

#1568533
RE: Simular to PIVOT Table, but not

dwain.c (12/13/2012)
How is it that I knew in advance where that link was gonna take me? 😛
BWAAA-HAAAA!!!! I guess I have to work on being more subtle. 😛
--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)

December 13, 2012 at 6:49 pm

#1568532
RE: Simular to PIVOT Table, but not

CELKO (12/12/2012)
SQL is a data base language and it was never meant to reporting [font="Arial Black"]or complex calculations.[/font] Do not cut wood with a screw driver.
Heh... yeah... I know...
--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)

December 13, 2012 at 5:29 am

#1568263
RE: Update statement question

CELKO (11/27/2012)
It's not about to nor is it ever likely that the proprietary version of UPDATE will ever be deprecated because too many people have written code that uses...
--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)

December 13, 2012 at 5:19 am

#1568262

Viewing 15 posts - 27,871 through 27,885 (of 59,101 total)