Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,701 through 20,715 (of 59,098 total)

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
RE: Project suggestion for a noob

There is very little difference between editions of SQL Server according to what a Noob should start with. About 8 months ago I interviewed a handful of "developers" and...
--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:39 pm

#1798478
RE: Here are some SQL Server Interview Questions

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: Tell me all...
--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:33 pm

#1798477
RE: Here are some SQL Server Interview Questions

GilaMonster (5/15/2015)
David Webb-CDS (5/15/2015)
You gather the customer, the developer, the network guys, the storage guy, and the server guy in a conference room. They all swear that nothing has...
--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:27 pm

#1798476
RE: Finding Problem Code

Gail Wanabee (5/15/2015)
Eric,
If your users claim the server is slow, I would do several things:
> Ask them, "Compared to what?" This is not a smart *** question. It's a realistic...
--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 15, 2015 at 10:14 pm

#1798414

Viewing 15 posts - 20,701 through 20,715 (of 59,098 total)