Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,056 through 8,070 (of 59,072 total)

Reply To: is there any better way to export SQL server data into csv file?

That's certainly another viable option and it has kind of a user interface built 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)

December 23, 2019 at 4:24 pm

#3710011
Reply To: High Page File Usage

Yes, partially (although it almost never hurts to do so). It may also be an indication that you have code to fix that might still blow through whatever memory 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)

December 23, 2019 at 4:19 pm

#3710008
Reply To: Learn to Change

I think it's actually a much more valuable skill to learn when to NOT change. I've seen a lot of so called "improvements" to things, especially in the world 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)

December 23, 2019 at 4:09 pm

#3710005
Reply To: Double Check Your Math

It's not bad enough that some of us have problems with the likes of using the wrong kind of rounding or what have you. SQL Server "helps" us make some...
--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)

December 23, 2019 at 3:07 pm

#3709969
Reply To: Server Hardware or Coffee?

On the subject of the tired adage of "Good/Fast/Cheap... Pick 2.", I end up saying to people that tell me that, "Ummmm... Ok... I thought you were a professional". 😉
There'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)

December 23, 2019 at 2:42 pm

#3709964
Reply To: Stairway to Database Design Level 4: Building a Schema

Just be mindful of the possible surprise such a change could cause if the departure data has a midnight time.
--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)

December 20, 2019 at 10:19 pm

#3709705
Reply To: Looking for a very heavy query against AdventureWorks DW database for DEMO

autoexcrement wrote:
How about some nice triangular joins done inside a cursor? Jeff Moden: Look Away.
Oddly enough, I was going to suggest Triangular Joins. I decided not to because I don't...
--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)

December 20, 2019 at 10:16 pm

#3709704
Reply To: PIVOT taking forever unless temp table var used

torpkev wrote:
Thanks all - I thought there might just be some super simple reason like PIVOT just works better with in-memory data etc.
There might be!!! Did you try what 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)

December 20, 2019 at 3:03 pm

#3709603
Reply To: Scalar function use results of exec(@sql)

david_h_edmonds wrote:
Hi John, thanks for the reminder about SQL injection. I think we are ok in this case.
Despite your thoughts, you're still concatenating the table name without checking to see...
--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)

December 20, 2019 at 2:58 pm

#3709592
Reply To: update for SQL server 2019

Thom A wrote:
The KB was released due to an error in the RTM edition of SQL Server 2019.
Like I said in a different post, new versions of SQL Server scare...
--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)

December 20, 2019 at 2:39 pm

#3709590
Reply To: Collect user stats before working to decommission the server

If you wanted to be absolutely sure, you could change what is captured in the error log to log both successful and unsuccessful logins and then bounce the service to...
--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)

December 20, 2019 at 2:17 pm

#3709586
Reply To: Question of the day - how to submit

Awesome! Looking forward to seeing it, John!
--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)

December 20, 2019 at 2:10 pm

#3709585
Reply To: PIVOT taking forever unless temp table var used

What do you get when you write it with straight criteria instead of selecting from the sub-query?
--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)

December 20, 2019 at 1:51 pm

#3709577
Reply To: how to find duplicate rows, dynamically, with a loop
Jonathan AC Roberts wrote:
Jeff Moden wrote:
Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different. However (and you know this...
- This reply was modified 6 years, 6 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)
December 20, 2019 at 1:42 pm

#3709573
Reply To: how to find duplicate rows, dynamically, with a loop
Jonathan AC Roberts wrote:
```
SELECT CONCAT('
SELECT ''', QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),  ''' [TABLE_NAME], COUNT(*) COUNT 
  FROM (SELECT ',x.c, '
         ...
```
--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)
December 19, 2019 at 11:22 pm

#3709278

Viewing 15 posts - 8,056 through 8,070 (of 59,072 total)