Jeff Moden

Forum Replies Created

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

RE: Help with switching partition - getting error x contains primary key for constraint...

sherrerk (1/28/2014)
We have a situation that data in a partition occasionally gets put into a wrong partition because the partition function was not changed properly.
My suggestion would be to fix...
--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 1:14 pm

#1684055
RE: Powershell code encapsulation into exe with dynamic parameters

AlexMcCo (1/28/2014)
Might be anyone could help with solution. I need to encapsulate powershell logic into exe. At the moment I am calling *.ps1 file using an agent job with passing...
--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 1:13 pm

#1684051
RE: Vulnerable to SQL Injection third-party API

Cadavre (1/28/2014)
Not sure where this post should go. . .
I have a third party API that I pass data from my database to. The UI front end of my database...
--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:52 pm

#1684040
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

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