Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 59,098 total)

Reply To: Transfer SQL Table Data into Excel

Why not just create a stored procedure to produce the data and have Excel pull the data on demand? That way, you don't end up creating files for a bazillion...
--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)

August 23, 2022 at 3:38 pm

#4079773
Reply To: Extended Events: using ATTENTION Event to log external apps timeouts.
VoldemarG wrote:
Jeff, why do you think deadlocks could be an issue?
It was a suggestion based on previous experience that was meant to prompt you into checking for them. That worked. ...
- This reply was modified 4 years, 1 months ago by Jeff Moden.
--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)
August 23, 2022 at 1:56 am

#4079488
Reply To: Using LAG to return prior non null value

Awesome news about the Substring parameters. And, I've not run it but it looks like your @SmearStart will likely do the trick.
All of that and your previous column additions 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)

August 23, 2022 at 1:41 am

#4079484
Reply To: calculation for year month and quarter with date dimension table

jeannier175 wrote:
I was able to resolve the issue i just deleted the date filter in the where clause.
Have you taken a look at your execution plan since you've done 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)

August 23, 2022 at 1:37 am

#4079482
Reply To: When Is Technology Good Enough?

daniel_jacob wrote:
But in a general sense, am more frustrated by the drive to add new 'Big' features, rather than perfect what we have.
That's one of my biggest frustrations with Microsoft.
[quote-1...
--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)

August 23, 2022 at 1:29 am

#4079481
Reply To: Turning Col into Multiple Rows

Have a look at the following article to support such "Dynamic CrossTabs". Use MAX() instead of SUM() like Scott Pletcher did. With the understanding that I have little love 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)

August 22, 2022 at 5:03 pm

#4079377
Reply To: Help with Copying backup files and capture results in output file with details

SQLisAwe5oMe wrote:
Thanks Jeffrey, do you have a link you can refer me to?
It's part of the windows operating system. Just Google 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)

August 22, 2022 at 4:56 pm

#4079347
Reply To: When Is Technology Good Enough?

To be more specific, the "improvements" to TempDB, especially the one that adds TF1117 functionality (grow all files equally) and cannot be disabled even temporarily for TempDB because a bunch...
--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)

August 22, 2022 at 4:52 pm

#4079346
Reply To: Reconcile employees with multiple IDs into Unique IDs

Hopefully, that's true. The last person that told me that was at a company the I worked at temporarily. They told me that AFTER I had already seen that 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)

August 22, 2022 at 3:09 am

#4079103
Reply To: Reconcile employees with multiple IDs into Unique IDs

masterelaichi wrote:
However, every employee has a unique SSN.
For the love of all that is holy in SQL Server, please tell me that your SSNs are NOT in plain, 9 digit...
--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)

August 22, 2022 at 3:01 am

#4079100
Reply To: SQL Query

Ok... no interest from the OP. Unsubscribing.
--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)

August 22, 2022 at 12:58 am

#4079086
Reply To: Using CONTINUE

It's a funny thing how things sometimes work out. I told myself that I'd spend a little time cruising the net after I was done with work today and then...
--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)

August 22, 2022 at 12:53 am

#4079085
Reply To: When Is Technology Good Enough?

It's easy to find out when technology is "good enough"... just wait a bit for the next change. The trouble is, it's frequently the prior change that was good enough...
--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)

August 22, 2022 at 12:38 am

#4079084
Reply To: Extended Events: using ATTENTION Event to log external apps timeouts.

Have you checked the SQL Server logs for deadlocks? And I'm pretty sure that the MS documentation is correct about MicroSeconds.
--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)

August 21, 2022 at 8:15 pm

#4079051
Reply To: Flow Control Problem with multiple statements

Perhaps it wasn't a trailing space. Perhaps it's a "hard space" (Char 160 in ASCII) or something else like a "Control Character" (ASCII characters <= CHAR(31), which includes things 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)

August 21, 2022 at 8:08 pm

#4079050

Viewing 15 posts - 2,941 through 2,955 (of 59,098 total)