Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,681 through 7,695 (of 59,072 total)

Reply To: Columnstore indexes and compatibility

Grant Fritchey wrote:
peter.cox wrote:
Cheers Grant
Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.
I may ask a loaded question at one your SQL Bits...
--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)

February 26, 2020 at 4:16 am

#3728785
Reply To: Running generic query for table information

Instead of using WITH (NOLOCK) on every system table, use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED for the session. That way you don't have to worry about missing one and,...
--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)

February 26, 2020 at 4:11 am

#3728784
Reply To: Global Unique Identifier Field

There are a lot of disadvantages to GUIDs as key columns in indexes, especially Clustered Indexes. They basically violate a good number of what most people consider to be desirable...
--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)

February 26, 2020 at 4:07 am

#3728782
Reply To: Inserting In the Middle

I've not studied Python but took a guess at it according to what other programs do. Of course, that was incorrect because Python does it based on a different paradigm. ...
--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)

February 26, 2020 at 3:45 am

#3728780
Reply To: Business Justifications for Upgrading SQL 2012 to SQL 2019

Security improvements and the fact that 2012 is now 7 years old. The biggest advantage is that there are a fair number of features that were formally only available 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)

February 26, 2020 at 3:40 am

#3728779
Reply To: Verify Server online status using sql server query

Let me know how it works out for 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)

February 26, 2020 at 3:17 am

#3728778
Reply To: varbinary(max)
I cribbed the example code given in the original post and added some line breaks. It looks like the following...
```
Select LastName, EmpNumber, Granted, Denied, ID_Picture 
FROM EmployeeCards...
```
--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)
February 25, 2020 at 3:48 pm

#3728637
Reply To: Introduction to Indexed Views in SQL Server

This is a great introduction to Indexed Views, Archana. It's well written, the order of revelation in the article is perfect, the example code is nice and simple and very...
--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)

February 25, 2020 at 2:47 pm

#3728601
Reply To: Duplicate Statistics Search and Destroy

This is an awesome idea! Thanks for taking the time to both suggest it and provide code for it. I'll check out the code but, at first blush, it looks...
--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)

February 24, 2020 at 7:54 pm

#3728381
Reply To: Toilets and Your Systems

Nope. I'm not saying that industry standards are bad. Just make sure that they're not going to cause damage because, like anything else, even an industry standard can be bad/incorrect...
--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)

February 24, 2020 at 7:02 pm

#3728365
Reply To: Toilets and Your Systems

GeorgeCopeland wrote:
To bring the discussion back to topic, what I take from the examples is this: Industry standards are there for a reason. Find out what they are and follow...
--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)

February 24, 2020 at 6:25 pm

#3728350
Reply To: Toilets and Your Systems

jschmidt 17654 wrote:
We had one of those radioed chiefs on USS Seahorse. "Commence Ventilating", then mistook the low pressure blow switches for the blower hull valve switches and we popped 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)

February 24, 2020 at 6:11 pm

#3728345
Reply To: How to get specific database name for one common table

Do a search for "ms for each db sql server" and follow your nose to write some custom code.
--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)

February 24, 2020 at 3:10 pm

#3728223
Reply To: Toilets and Your Systems

John N Hick wrote:
Dang - things weren't so complicated for us ground-pounders.
No? I think that getting shot at, possibly stepping into a hidden dung coated set of spikes, setting off a trip...
--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)

February 24, 2020 at 3:07 pm

#3728222
Reply To: Performance Issue After SQL 2019 Upgrade

+1,000,000 on that post, Grant.
--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)

February 24, 2020 at 1:55 pm

#3728178

Viewing 15 posts - 7,681 through 7,695 (of 59,072 total)