Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,061 through 33,075 (of 59,099 total)

RE: Are the posted questions getting worse?

Tom.Thomson (7/29/2011)
Jeff Moden (7/29/2011)
Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn'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)

July 29, 2011 at 5:26 pm

#1361168
RE: Are the posted questions getting worse?

Ninja's_RGR'us (7/29/2011)
Jeff Moden (7/29/2011)
Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn'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)

July 29, 2011 at 5:18 pm

#1361166
RE: CPU utilization is 100%

Very cool. Thanks for the details, folks. I appreciate it a LOT because I was just a wee bit (a lot, actually) out of my element.
--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)

July 29, 2011 at 5:16 pm

#1361165
RE: Using xp_cmdshell to copy files to a sql server on a different domain

opc.three (7/29/2011)
Jeff Moden (7/29/2011)
Heh... and once you learn PowerShell, you can run that from xp_CmdShell in T-SQL. 😉
This is me not taking the bait Jeff 😛
😀 Not even if...
--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)

July 29, 2011 at 10:53 am

#1360941
RE: indexing a converted datetime column

ericwenger1 (7/28/2011)
I have a request to allow the user to search on a converted datetime column(i.e. convert(varchar,column_name,101) mm/dd/yyyy). Is there
any trick to indexing this column. I guess if it were...
--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)

July 29, 2011 at 10:47 am

#1360936
RE: Using xp_cmdshell to copy files to a sql server on a different domain

Heh... and once you learn PowerShell, you can run that from xp_CmdShell in T-SQL. 😉
--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)

July 29, 2011 at 10:07 am

#1360908
RE: Issue on Flat Files to tables with fixed positioning: Thanks

varun_2003 (7/28/2011)
Hi,
I do have couple of questions on the task which I trying to break my head and it would be greatly appreciated for any answer:
I do have a flat...
--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)

July 29, 2011 at 10:02 am

#1360903
RE: how to find ASCII characters in a table?

ranuganti (7/29/2011)
I have a table in which a couple of columns (varchar) is having ASCii characters so how do i find them using a sql query?
Thanks.
ALL characters in a...
--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)

July 29, 2011 at 9:43 am

#1360888
RE: Are the posted questions getting worse?

Koen Verbeeck (7/28/2011)
Well Jeff, I voted for you at the Exceptional DBA awards.
Not only because you are the only one I know from that list, but also because of your...
--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)

July 29, 2011 at 7:02 am

#1360740
RE: Are the posted questions getting worse?

Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn't one and except...
--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)

July 29, 2011 at 7:00 am

#1360738
RE: CPU utilization is 100%

Lavanyasri (7/29/2011)
Hi Jeff,
So is it compulsory to change the server name ??
"Compulsory"? I don't actually know. According to Remi above, he's never had a problem with it....
--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)

July 29, 2011 at 6:51 am

#1360729
RE: scramble data

Ghanta (7/28/2011)
... but that did not guarantee new addresses for everyone. Your script helps me out rite away. Thanks again.
You're welcome and thanks for the feedback but, like I said...
--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)

July 28, 2011 at 7:17 pm

#1360524
RE: Red Gate Data Generator

sindhigrl (7/28/2011)
Ok, so how do you propose I build test/dev? The developers need data. Are you suggesting I generate all fake data? Their argument is that the users need 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)

July 28, 2011 at 7:12 pm

#1360523
RE: scramble data

Ah... almost forgot. I got your email. I know you were probably "under the gun" for this task but I don't normally have the time to respond with...
--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)

July 28, 2011 at 6:52 pm

#1360519
RE: scramble data

p.s. Please post back if you have any difficulty in randomizing the numerics in each address.
--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)

July 28, 2011 at 6:47 pm

#1360518

Viewing 15 posts - 33,061 through 33,075 (of 59,099 total)