Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,601 through 24,615 (of 59,099 total)

RE: migration to sql 2008 r2

DBA-640728 (1/22/2014)
i am planning to do an instance sql 2008 with 20 databases around 2-10 gbs each migration to a sql 2008 r2 sp2 instance (new storage), does anyonethink 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)

January 28, 2014 at 12:44 pm

#1684037
RE: Triggers

You can actually control what order everything is done by triggers. Note that I did NOT say you could control the order of triggers (other than the first 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)

January 28, 2014 at 12:33 pm

#1684033
RE: Comparing string with date

Lempster (1/28/2014)
As the first reply states, it would be easier to this using date or datetime data types, but assuming that you are locked in to using the varchar data...
--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)

January 28, 2014 at 12:26 pm

#1684031
RE: If Statement

crazy_new (1/28/2014)
Yeah there are more than one, but there aren't duplicates, one address can be used more than once...
Insofar as the address is concerned, those are duplicates.
--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)

January 28, 2014 at 11:50 am

#1684026
RE: need T-SQL to delete ALL subdirectories within a Directory

The only thing that I didn't agree with there is the notion that xp_CmdShell is a security hole. 😉
--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)

January 28, 2014 at 11:37 am

#1684022
RE: Pros and Cons of a Central Management Server

Thank you both. That's more inline of what I thought CMS should be for. What I've found is that a lot of people have written PoSH (interesting abbreviation...
--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)

January 28, 2014 at 11:32 am

#1684021
RE: Automatically import csv content into SQL Server

Deries (1/28/2014)
Hi Luis,
I read your post and tried that for testing. I being a developer it didnt allow me to do insert bulk load because of the rights issue. Thats...
--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)

January 28, 2014 at 11:21 am

#1684019
RE: FizzBuzz

GilaMonster (1/28/2014)
chillw1nston (1/28/2014)
--Now scalable, set based and added a fizzbuzz!
DECLARE @threshold int = 100
;WITH numbers ( seqnum )
...
--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)

January 28, 2014 at 9:05 am

#1683983
RE: Forum Etiquette: How to post Reporting Services problems

This is a really cool and helpful article, Leigh. It's been something that has been needed for a very long tme so that people can get the help they...
--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)

January 28, 2014 at 8:52 am

#1683972
RE: Forum Etiquette: How to post Reporting Services problems

andrew.edgar (1/28/2014)
Good article, however...
Most organisations I have worked for would take disciplinary action against any employee who was found to be posting source code from within the organisation, so best...
--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)

January 28, 2014 at 8:50 am

#1683971
RE: Pros and Cons of a Central Management Server

Roy Ernest (1/27/2014)
So far from my personal use, the pros out weigh the cons. We have been using CMS for a very long time and have not found an issue.
So,...
--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)

January 28, 2014 at 8:22 am

#1683950
RE: Are the posted questions getting worse?

Revenant (1/27/2014)
GilaMonster (1/27/2014)
Sometimes I wonder if people really want help.
"Sample data please"
"I don't see the point" "It won't be of any benefit"
"Expected results please"
"It's not going to help"
Yes, they do....
--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)

January 27, 2014 at 11:23 pm

#1683798
RE: Are the posted questions getting worse?

GilaMonster (1/27/2014)
Sometimes I wonder if people really want help.
"Sample data please"
"I don't see the point" "It won't be of any benefit"
"Expected results please"
"It's not going to help"
The person that 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)

January 27, 2014 at 11:16 pm

#1683795
RE: Volunteering to gain SQL experience

wolfkillj (1/27/2014)
Jeff Moden (1/25/2014)
Also, spend an hour to either sit down and design a simple business card with the area of SQL Server that you'd like to work with on...
--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)

January 27, 2014 at 11:05 pm

#1683794
RE: Value of @@DBTS / timestamp column

Ah, my apologies. I read that the return datatype of @@DBTS is VARBINARY in BOL and didn't consider the source (TIMESTAMP) is 64 bits. Thanks for the correction.
Guess...
--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)

January 27, 2014 at 10:47 pm

#1683791

Viewing 15 posts - 24,601 through 24,615 (of 59,099 total)