Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,446 through 23,460 (of 59,099 total)

RE: Would like some feedback on contractors as employers

Do you live in the USA and, if so, what state?
--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)

June 11, 2014 at 8:50 am

#1720775
RE: Can some one confirm that - It is possible to find table size and in that table each row size.

You can use sys.dm_db_index_physical_stats in the "DETAILED" mode to find the min, max, and average row size of clustered index rows, which is the table data itself. LOB 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)

June 11, 2014 at 8:31 am

#1720766
RE: Need help on priorty to run query (urgent)

But that's what I'm talking about. That doesn't sound "fully durable" to me but I could be mistaken in what my definition of "fully durable" means.
--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)

June 10, 2014 at 10:21 am

#1720498
RE: How to insert the results returned using 'exec StoreProc with result sets' when called from a another proc

wall str33t (6/10/2014)
Nope, not even along the same lines as what to what I am trying to do. I am aware of your problem though, you could create a permanent...
--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)

June 10, 2014 at 10:19 am

#1720496
RE: Issue with a slow Query

GilaMonster (6/10/2014)
wall str33t (6/9/2014)
In clauses are generally slower because people write them instead of joins,
Are you sure about that? Got some reproducible examples which show that 'ins are generally slower...
--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)

June 10, 2014 at 10:17 am

#1720495
RE: How to insert the results returned using 'exec StoreProc with result sets' when called from a another proc

wall str33t (6/9/2014)
I don't think you understand my question as it is not a simple select insert, and of all the examples I've seen I can't find one that does...
--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)

June 10, 2014 at 9:39 am

#1720467
RE: Need help on priorty to run query (urgent)

GilaMonster (6/10/2014)
Jeff Moden (6/10/2014)
Grant Fritchey (6/9/2014)
SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the database. You...
--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)

June 10, 2014 at 6:50 am

#1720366
RE: The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value.

BokBob (6/9/2014)
hi All,
My below proc gives me this error.. "The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value."
Please help...
===================================================================
alter...
--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)

June 10, 2014 at 6:01 am

#1720343
RE: Need help on priorty to run query (urgent)

Grant Fritchey (6/9/2014)
SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the database. You can't both SELECT...
--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)

June 10, 2014 at 5:46 am

#1720341
RE: Dirty Bit keeps getting set on SQL Server Logs Drive

Dunno if this helps, but my Assistant DBA (Mr. Google) found this...
http://support.microsoft.com/kb/321939
He also found a bunch of other things that you might want to take a look at. Here's...
--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)

June 9, 2014 at 5:14 pm

#1720248
RE: Dirty Bit keeps getting set on SQL Server Logs Drive

Sorry, Francis... I've never seen such a thing but, hopefully, my reply will serve as a "bump" on this issue for you.
--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)

June 9, 2014 at 5:06 pm

#1720245
RE: Issue with a slow Query

wall str33t (6/9/2014)
...always avoid "in" clauses
Since they're frequently faster than regular Inner Joins, why would I want to do that?
--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)

June 9, 2014 at 2:58 pm

#1720226
RE: Interview Questions

ChrisM@Work (6/9/2014)
Jeff Moden (6/6/2014)
ChrisM@Work (6/6/2014)
julian.fletcher (6/6/2014)
.. I should have said that we're looking for developers to work on all parts of a particular product; both the C# and the 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)

June 9, 2014 at 2:21 pm

#1720212
RE: How to insert the results returned using 'exec StoreProc with result sets' when called from a another proc

Yes. Lookup INSERT/EXEC in Books Online. Basically, you need to precreate the target table and then you use INSERT with a column list followed by the EXEC just...
--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)

June 9, 2014 at 9:03 am

#1720129
RE: Just curious, what are your SQL pet peeves ?

thomashohner (6/8/2014)
Okay I really feel stupid after looking at this some more. :blush:
I very much appreciate your humility here because it's one of those things that I hold most dear...
--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)

June 8, 2014 at 9:41 am

#1719965

Viewing 15 posts - 23,446 through 23,460 (of 59,099 total)