Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,061 through 21,075 (of 59,098 total)

RE: Delete or truncate

Since TRUNCATE is a DDL statement, might it be in the default trace? Haven't used the default trace in a million years so can't recall off the top 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)

April 14, 2015 at 8:14 am

#1790815
RE: Trying to Avoid Dynamic SQL

And to be sure, the query for the view would just be...
SELECT columnlist FROM databaseA.dbo.table UNION ALL
SELECT columnlist FROM databaseB.dbo.table UNION ALL
SELECT columnlist FROM databaseC.dbo.table UNION ALL
etc...
Don't use "*" for...
--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)

April 14, 2015 at 8:12 am

#1790813
RE: Trying to Avoid Dynamic SQL

sdownen05 (4/14/2015)
Jeff,
I guess I was confused about NVARCHAR(MAX). I thought the max was 4000 characters, because when I print the results of my dynamic query it will cut it off....
--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)

April 14, 2015 at 8:08 am

#1790810
RE: Querying Active directory

This is an interesting question. I don't know the answer but I'm happy to "bump" it for you.
Anyone have a clue on this? Seems like it could...
--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)

April 14, 2015 at 7:33 am

#1790789
RE: ACE.OLEDB.12.0' provider is not registered on the local machine

niladri.primalink (4/13/2015)
Hi Jeff,
Thanks for your quick reply.
The below link has helped me to solve my problems
Thanks once again.
Thanks for the feedback. That appears to be for Office 2007...
--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)

April 14, 2015 at 7:05 am

#1790782
RE: What is Database Continuous Integration?

Heh... continuous integration is the only way that you can make the maximum number of mistakes before anyone can even blink because, although humans can really make a mess 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)

April 13, 2015 at 11:57 pm

#1790675
RE: After Six Months On The Job What Challenges Remain?

Considering that there were more than 30 different hacks trying to get something up and running quickly and then hacking at it more to add more functionality quickly over 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)

April 13, 2015 at 11:54 pm

#1790673
RE: Using Case Within PIVOT portion of Crosstab query

Stop using Pivot altogether. Just use a CROSSTAB, which is driven by CASE statements to begin with. See the following article for a primer.
http://www.sqlservercentral.com/articles/T-SQL/63681/
As a bit of 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)

April 13, 2015 at 11:48 pm

#1790671
RE: Trying to Avoid Dynamic SQL

sdownen05 (4/13/2015)
There are two limitations that I see. First, the queries are fairly large, so I bump up against the max. I know I can split it up, 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)

April 13, 2015 at 11:42 pm

#1790670
RE: The Opportunistic Hacker

Wow! Seriously? People actually do that? Why the hell would ANYONE in their right mind trust such a person they've just met with their laptop? That'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)

April 13, 2015 at 11:38 pm

#1790668
RE: ACE.OLEDB.12.0' provider is not registered on the local machine

niladri.primalink (4/13/2015)
Hi All,
I have installed SQL server 2014 and my office is also 2013 64 bit. when i am trying to upload excel file into SQL server I am getting...
--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)

April 13, 2015 at 11:32 pm

#1790667
RE: Today's Random Word!

Eirikur Eiriksson (4/13/2015)
djj (4/13/2015)
Revenant (4/13/2015)
Ed Wagner (4/13/2015)
whereisSQL? (4/13/2015)
Ed Wagner (4/13/2015)
eccentricDBA (4/13/2015)
Ed Wagner (4/13/2015)
crookj (4/13/2015)
djj (4/13/2015)
Eirikur Eiriksson (4/13/2015)
Ed Wagner (4/13/2015)
djj (4/13/2015)
Ed Wagner (4/13/2015)
BWFC (4/13/2015)
Bunny
Bugs
Fudd
Duck
l'orange
Dinner
Brunch
Fun Cooking
gourmandize
Gourmet
Foodie
Taste
Refined
Silver
Lining
Red
--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)

April 13, 2015 at 7:22 pm

#1790652
RE: how to track SP's to tempdb usage

Brandie Tarvin (4/13/2015)
edyeh (4/13/2015)
I did an analysis showing procs that use high I/O and cpu resources, but I'd like to isolate the procs using the tempDB the most without going...
--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)

April 13, 2015 at 7:19 pm

#1790651
RE: excel destination and sum

This post is nearly two weeks old and, up to this instant, you don't have an answer even though it's for an incredibly simple problem. Before you post again,...
--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)

April 13, 2015 at 7:08 pm

#1790650
RE: how to track SP's to tempdb usage

edyeh (4/12/2015)
it's pretty much a single purpose database and it has crazy numbers on the write waits on the tempdb and high workfile numbers.
ed
Understood. My next question is why...
--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)

April 12, 2015 at 8:35 pm

#1790417

Viewing 15 posts - 21,061 through 21,075 (of 59,098 total)