Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,671 through 20,685 (of 59,072 total)

RE: How to eliminate deadlocks involving 'Select' statements

bray_tim (5/17/2015)
The deadlock victim is running at the serializable isolation level. Are you sure you need this. I would suggest READ COMMITTED.
Before everyone drops a ton of bricks on you...
--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)

May 17, 2015 at 8:49 pm

#1798527
RE: What is the best way to copy the tables of a database...

How often do you want to synchronize the DDL? Are you also looking to synchronize the data? If so, how often?
Can the changes be "destructive" as in total...
--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)

May 17, 2015 at 8:45 pm

#1798526
RE: Here are some SQL Server Interview Questions

TomThomson (5/17/2015)
Jeff Moden (5/16/2015)
I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.
Me: ...
--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)

May 17, 2015 at 8:13 pm

#1798524
RE: How to track a sqlserver login if password changed how to know who has changed its a 2005 standard edition

naga.rohitkumar (5/16/2015)
yes i have followed this but not working and its throwing errors
our environment has 2008 and 2005 sqlservers and they are standard versions in that case how can...
--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)

May 17, 2015 at 7:56 pm

#1798521
RE: How to track a sqlserver login if password changed how to know who has changed its a 2005 standard edition

It's a funny thing... If most people took the time to lookup the real original definition of "geek", they'd never use the word ever again.
It's also funny that "hacker" 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)

May 17, 2015 at 6:59 pm

#1798513
RE: QUESTION ABOUT MULTIPLE EXCEPT STATEMENTS

I'm amazed at this question for 2 reasons...
1) The coverage for such a question in Books Online is not obvious. You actually have to infer that such a capability...
--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)

May 17, 2015 at 4:26 pm

#1798510
RE: Help needed to find string before character when character appears mutliple times

craig.budd (5/17/2015)
Thanks Eirikur.
I have got it working with the following script.
create table #temp (Value varchar(500), Number int)
insert into #temp
(Value, Number)
select Source, (select charindex('\', reverse(Source))) from Table
select * from #temp
select distinct(left(Value,...
--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)

May 17, 2015 at 7:59 am

#1798497
RE: Boring or Scripting

Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does very well through T-SQL but people...
--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)

May 17, 2015 at 7:57 am

#1798496
RE: The Service Pack Fiasco

Agreed. I guess that's what I'm griping about. They don't actually know how to test for what or that "what" even exists.
--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)

May 17, 2015 at 6:57 am

#1798493
RE: The Service Pack Fiasco

TomThomson (5/14/2015)
Jeff Moden (5/13/2015)
TomThomson (5/13/2015)
Jeff Moden (5/11/2015)
MS has to do one very important thing... they need to slow down and do service packs 100% correct. SPs are supposed 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)

May 16, 2015 at 10:39 pm

#1798484
RE: Temporary Stored Procedures

Jeff Moden (5/9/2015)
sanjarani (5/9/2015)
One of many SQL Servers features that is hardly ever used because alternative methods are more suitable.
Please explain your "alternative methods" and how they are "more suitable".
What...
--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)

May 16, 2015 at 10:36 pm

#1798483
RE: Searching for Plans

It's never too late for such advice.:w00t:
And I have to agree... if you can actually get a 50% query performance increase by changing hardware, you're pretty lucky.
Performance is in 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)

May 16, 2015 at 10:27 pm

#1798482
RE: MCSA 70-461 Question

Nah... we all take turns learning from each other. To coin a phrase, "I learn from you, you learn from me, and people learn from us and that's good...
--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)

May 16, 2015 at 10:15 pm

#1798481
RE: Backup files not created

Igor Micev (5/14/2015)
Hi All,
Just to share with the sql folks that the problem was resolved by upgrading the instance with CU1 and CU2. Now there is no issue with 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)

May 16, 2015 at 9:59 pm

#1798480
RE: DB crashed

Eirikur Eiriksson (5/16/2015)
shivakumar.623 (5/14/2015)
My database was crashed then How to identified in particular server particular database was crashed
Quick question, (and piling on the previous questions) can you tell us what...
--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)

May 16, 2015 at 9:46 pm

#1798479

Viewing 15 posts - 20,671 through 20,685 (of 59,072 total)