Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,006 through 25,020 (of 59,099 total)

RE: Backup to local device

shashianireddy 30786 (12/26/2013)
BACKUP DATABASE databasename to disk='c:\databasename.bak'
That will not work to produce the backup on any machine other than the server itself. You have to use a UNC...
--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 26, 2013 at 5:59 am

#1675937
RE: Update SQL within Procedure perform Slow

anupamk (12/26/2013)
Hi,
I have 5-6 Update SQL within a Procedure. These Update SQL are 3-4 liner and are updating Columns based on some other Column in same table and some are...
--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 26, 2013 at 5:48 am

#1675933
RE: Physical Operators

ramana3327 (12/25/2013)
Hi what is the main difference b/n mergejoin, hash join & nested loop join? In which cases those will form? Please tell me which is the very bad performance...
--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 26, 2013 at 5:38 am

#1675930
RE: How will get distinct records in SQL table?

SELECT DISTINCT Name
FROM dbo.YourTable
;
But, beware... this type of logic is frequently due to bad table or data design and can lead to some mighty slow queries.
--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 26, 2013 at 5:10 am

#1675928
RE: Santa's Reindeer

Fun question and I screwed it up. 😀
--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 26, 2013 at 5:04 am

#1675927
RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

yuvipoy (12/26/2013)
Pasting couple of rows is not a problem but what is the logic...?
Post the couple of rows and tell me what's in them and then we'll see what we...
--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 26, 2013 at 5:02 am

#1675926
RE: Output old/new values of a column from an audit table

You're welcome and Happy Christmas Eve.
--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 24, 2013 at 7:12 pm

#1675849
RE: The Geek Christmas Poll

To borrow a concept from one of my favorite old Star Trek episodes, I long for the simplicity of play.
--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 24, 2013 at 7:03 pm

#1675847
RE: Output old/new values of a column from an audit table

LinksUp (12/23/2013)
Try this:
;with cte as
(
select *, ROW_NUMBER() over(order by old_ind_id) as RowNum
from #audit_Person
)
select 'old', old_ind_id, old_login, first_name, last_name, email_addr, created_dt, updated_dt,RowNum
from cte
union...
--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 24, 2013 at 6:52 pm

#1675844
RE: How Do You Find a DBA?

Core6430 (12/24/2013)
The recruiter spent an hour talking about his car. Didn't ask me anything about my skills, experience, or work history. Utter waste of time.
Heh... I agree. You didn'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)

December 24, 2013 at 5:58 pm

#1675834
RE: Split a variable length string without using a WHILE loop

ScottPletcher (12/24/2013)
Jeff Moden (12/24/2013)
ScottPletcher (12/24/2013)
If you don't have any data longer than 24 bytes (or so), it might be easier just to "brute STUFF" it:
Awesome! I don't believe anything...
--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 24, 2013 at 5:41 pm

#1675832
RE: Split a variable length string without using a WHILE loop

ScottPletcher (12/24/2013)
If you don't have any data longer than 24 bytes (or so), it might be easier just to "brute STUFF" it:
Awesome! I don't believe anything will come close...
--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 24, 2013 at 12:04 pm

#1675819
RE: How Do You Find a DBA?

Core6430 (12/24/2013)
I dislike using recruiters because getting the company name is like pulling teeth, and finding a half way decent one is a monumental feat. I once had one insist...
--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 24, 2013 at 11:41 am

#1675814
RE: Is sp_executesql reliable?

Ah... while I agree with being paranoid about the use of dynamic SQL, it should not be something that keeps you from using it when necessary. It's an incredibly...
--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 24, 2013 at 11:33 am

#1675812
RE: Maintanance

ramana3327 (12/24/2013)
How to check all the maintenance plans at same time. I want to test the migration so I saw that we have see all maintenance plans and take scripts...
--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 24, 2013 at 11:21 am

#1675807

Viewing 15 posts - 25,006 through 25,020 (of 59,099 total)