Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,851 through 23,865 (of 59,099 total)

RE: Find out which store procedures were fired

Koen Verbeeck (4/16/2014)
Since profiler is deprecated and to be fully replaced with Extended Events, you can be fairly certain it is possible with Extended Events as well.
We're still stuck on...
--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 16, 2014 at 7:39 am

#1706448
RE: Doing What It Takes To Get The Job Done

Jim P. (4/15/2014)
I've introduced more manager to the following:
You always have choice:
1. Cheap
2. Fast
...
--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 15, 2014 at 4:55 pm

#1706270
RE: How to hide objects (sp, views, tables) from a user?

This seems backwards to me. When you build the user the first time, it should have no privs other than PUBLIC. Then grant individual privs. Better yet,...
--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 15, 2014 at 7:12 am

#1706079
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

I agree. A CLR would be the best way and you made it easy enough for everyone to use. Thanks. The "Split" function in the original article...
--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, 2014 at 10:32 pm

#1705984
RE: Calculate tempdb size for Read commited snapshot enabled

vkundar (4/14/2014)
We have 8 data files for temp db of 10210 GB size and given 10240 GB as max size.
Are you sure? 10240GB is 10.2 Tera Bytes!...
--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, 2014 at 9:59 pm

#1705982
RE: convert column in qry1 and return unmatched

WHERE NOT 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)

April 14, 2014 at 9:35 pm

#1705978
RE: Doing What It Takes To Get The Job Done

It's a funny thing. I've learned to hate the phrase for many reasons. That's a real shame because it used to be about good people.
It's kind of like...
--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, 2014 at 9:30 pm

#1705977
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Thanks. I'll check it out.
BTW... you know you can attach spreadsheets to a post, right?
--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, 2014 at 9:00 pm

#1705972
RE: Execution Plan

sqlbuddy123 (4/3/2014)
Key lookup is bad, instead you can avoid this by using a covering index by including all those referred columns in the index itself.
--
SQLBuddy
To reiterate what has already...
--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, 2014 at 8:51 pm

#1705970
RE: Object already exists, but can't drop it!

It sounds like either you're in the wrong database when you're looking for things or the things are in the wrong database. They didn't get copied to the master...
--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, 2014 at 8:10 pm

#1705965
RE: Retrieve binary file from SQL Server

Confusing Queries (4/14/2014)
Hi All,
I have been trying to store binary file in a folder from the SQL Server.
Here is the code I am using to do this but, it 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)

April 14, 2014 at 8:08 pm

#1705964
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Miller (4/14/2014)
Anyway, after all this I ended up with BetterSplit being about 11% faster than the DelimitedSplit8K.
I'm not sure how you came up with that number. Please explain from...
--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, 2014 at 7:26 pm

#1705961
RE: Table Partitioning

You bet. Thanks for the feedback, Todd.
--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, 2014 at 11:33 am

#1705856
RE: Which is Better?

Here's another excellent link on the subject. The article also has other links. Gail Shaw is a Microsoft Certified Master and she has put together quite the writeup...
--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, 2014 at 10:49 am

#1705839
RE: Which is Better?

AndrewSQLDBA (4/14/2014)
Hello Everyone
I am reviewing code in a SQL database that was coded by a BA and a Old oracle developer. Never a good idea to begin with. I am...
--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, 2014 at 9:02 am

#1705788

Viewing 15 posts - 23,851 through 23,865 (of 59,099 total)