Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,531 through 7,545 (of 59,091 total)

Reply To: Need some help getting info of people logged in, but from the POV of NON-Sysadm

Seems like a lot of work. Why not just use WITH EXECUTE AS OWNER at the beginning of the proc?
--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)

March 20, 2020 at 7:45 pm

#3735942
Reply To: How to check if a particular table is being used right now?

Finding the last access date and time doesn't tell you if it's currently being accessed. Why not just check sp_lock results for objects that have locks on them?
--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)

March 20, 2020 at 6:33 pm

#3735926
Reply To: Get the correct output

Steve Collins wrote:
...there's no point in looking back or carrying relics forward imo.
Dude! I'm right here! 😀
--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)

March 20, 2020 at 6:15 pm

#3735922
Reply To: Table Partition in Sql server with compression

From the sounds of it, you're a bit new to partitioning and all of the benefits and seriously negative caveats it can throw you.
Let's start at the beginning... Why do...
--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)

March 19, 2020 at 6:23 pm

#3735669
Reply To: Get the correct output

To Steve's good point...
From the posted input and the posted required output, it looks like there should only be a return if a given AlertID only has AlertTypeID's of both...
--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)

March 19, 2020 at 6:19 pm

#3735667
Reply To: Question on BCP and Azure

I don't use Azure and I've not used VB in a million years. However, the following link seems to have a fair bit of info that you might find applicable...
--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)

March 19, 2020 at 3:00 pm

#3735608
Reply To: SQL Is Always Going to be Popular

Oh... no question about trying something new being a good thing. That's actually how I got so involved with electronics, computers, and ultimately SQL Server (and many other programs including...
--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)

March 19, 2020 at 1:37 pm

#3735598
Reply To: SQL Is Always Going to be Popular

I don't know... if you consider that 100 hours is probably outside of your normal work hours and you spend 2 hours of the 100 every day on weekdays, 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)

March 18, 2020 at 11:38 pm

#3735468
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
Her being home isn't helping because she's also one of those folks that has to say everything she's doing out-loud as she's doing it. It's as bad...
--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)

March 18, 2020 at 5:24 pm

#3735403
Reply To: Are the posted questions getting worse?

Phil Parkin wrote:
Jeff, these may be for you (if you dare venture anywhere to buy them, that is!). I have a pair and they work a treat. Not that I...
--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)

March 18, 2020 at 5:17 pm

#3735400
Reply To: SQL Is Always Going to be Popular

Heh... I'm often told that SQL Server isn't the center of the Universe. My standard reply is "Cool! Let's turn it off and see if you're right!". 😀
Oddly enough, they...
--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)

March 18, 2020 at 5:02 pm

#3735398
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active and 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)

March 18, 2020 at 4:36 pm

#3735394
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I'm glad my wife isn't on this thread...
I'll bet she is too! 😀
--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)

March 17, 2020 at 9:05 pm

#3735152
Reply To: extract all data with week

I appreciate your humility, Phil, but I think Kruger-Dunning is in effect and you're drastically underrating your skills both in SSIS and as a writer.
--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)

March 17, 2020 at 3:53 pm

#3735066
Reply To: WITH Query definition not working

SQL Galaxy wrote:
Yeah, I checked that first query. some servers all available drive retrieved and some servers not retrieved. could you suggest me what kind of permission required for fetching all...
--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)

March 17, 2020 at 3:24 pm

#3735056

Viewing 15 posts - 7,531 through 7,545 (of 59,091 total)