Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,711 through 37,725 (of 59,098 total)

RE: Problems using :Connect in SQLCMD

Go to "Services" in Control Panel and make sure that the DTC service is running. Not only should it be running but it should probably also be set 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 13, 2010 at 10:33 pm

#1192513
RE: query like or something similiar

John N (7/13/2010)
Figured it out.. use SOUNDEX right?
I'm pretty sure I wouldn't use SOUNDEX... it's a little too "fuzzy" for my taste.
I haven't had to use it myself but...
--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 13, 2010 at 10:28 pm

#1192510
RE: Help Understanding Row_Number

RakeshRSingh (7/13/2010)
As per the execution of the SQL Statements that you have provided,
1. First the From clause will be processed
2. Then WHERE clause will be processed
3. Then SELECT clause will...
--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 13, 2010 at 10:22 pm

#1192506
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

A short, sweet, and brilliant article! Bravo Stephen and spot on on all points especially on working with your "customers".
There's only one problem with the scenario you're given... 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)

July 13, 2010 at 10:11 pm

#1192504
RE: Does adding Primary and Foreign Keys to an existing database mess with your SPs?

I agree with the others. Things could break if the DRI is violated or PKs aren't created using IDENTITY, etc.
My recommendation would be to do the same thing as...
--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 13, 2010 at 9:42 pm

#1192497
RE: SQL DBA to BI Developer Role

deepthi818 (7/13/2010)
Hi all
I am an SQL Server DBA with 3 years of experience, I have some experience in SSIS. I am not an expert in SSIS, but am looking at...
--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 13, 2010 at 9:31 pm

#1192496
RE: History Table

mbender (7/13/2010)
I plan on creating a sql trigger that before and after an update it inserts the data into a transaction history table. That way I have a before...
--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 13, 2010 at 9:28 pm

#1192495
RE: SSIS - importing 1000 tables

mazzz (7/13/2010)
Thanks Tod.
It's as I feared then - I will at any rate have 1000 distinct OLE DB Sources/Destinations to put together.
I counted the tables, there are actually 3000 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)

July 13, 2010 at 9:22 pm

#1192493
RE: Suggestion for points

Heh... who's going to decide what a good answer is... the Original Poster? Let me tell you some of the reasons why that's such a bad idea...
1. Despite...
--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 13, 2010 at 9:10 pm

#1192490
RE: Table as parameter

Here's an article on passing data as if it were a 1, 2, or 3 dimensional array...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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 13, 2010 at 8:51 pm

#1192488
RE: Try Catch alters behaviour of existing procedures

doobya (7/12/2010)
His post did not add anything to the discussion - it was therefore light trolling
forum dwellers do tend to get upset when the status quo / comfort zone 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)

July 13, 2010 at 7:42 pm

#1192480
RE: The Utilty

Steve Jones - Editor (7/12/2010)
jcrawf02 (7/12/2010)
mbricker-600840 (7/12/2010)
I agree whole-heartedly with Jeff. IT is there to serve. Too many people forget that.
Oh, and another thing, I certainly hope I provide service...
--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 13, 2010 at 7:21 pm

#1192475
RE: return calculated null as 0

LutzM (7/11/2010)
Ooops! My fault (never had / been forced to use it, fortunately)...
So, the correct answer would then be: use a c.u.r.s.o.r.? ;-):-D;-)
Absolutely NOT! 😉 Good setbased code is...
--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 13, 2010 at 7:12 pm

#1192472
RE: Performance on Views that span databases on multiple servers

TheSQLGuru (7/13/2010)
Grant Fritchey (7/12/2010)
If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in...
--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 13, 2010 at 7:07 pm

#1192470
RE: Function in Joining column degrades performance in 2008

aravind-305595 (7/13/2010)
Yes both are 2008 servers
Ok... then you might want to try the "computed column" thing that I suggested and that Howard materialized with code. You can (most likely,...
--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 13, 2010 at 6:30 pm

#1192456

Viewing 15 posts - 37,711 through 37,725 (of 59,098 total)