Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,761 through 8,775 (of 59,091 total)

Reply To: SQL Server Triggers.

My first recommendation would be to stop using such homegrown methods. Temporal tables work a fantastic treat and the audit table they leave behind is pretty much immutable with virtually...
--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 29, 2019 at 12:01 pm

#3675382
Reply To: sql server installation

Yes, but I wouldn't. I'd do the migration between the servers.
--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 29, 2019 at 11:51 am

#3675377
Reply To: SQL 2017 post migration memory issues

Grant Fritchey wrote:
Jeff Moden wrote:
Ahhh... I've got to disagree a bit. Instead of changing to comparability level, SQL Server 2017 does have the ability to use the old cardinality estimator at at...
--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 29, 2019 at 11:46 am

#3675375
Reply To: Index and fragmentation

... and read the following to answer most of your other questions...
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-2017
--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 29, 2019 at 2:19 am

#3675269
Reply To: update query help

Guras wrote:
I have a table with the following data . Some rows have col2 as null
col1 col2 col3
1 203 1232
2 null 2343
3 502 15566
4 null 4566
5 null 4545
6 601 4545
7...
--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 29, 2019 at 2:08 am

#3675262
Reply To: SQL 2017 post migration memory issues

Ahhh... I've got to disagree a bit. Instead of changing to comparability level, SQL Server 2017 does have the ability to use the old cardinality estimator at at least the...
--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 28, 2019 at 9:54 pm

#3675222
Reply To: Should Salary Information Be Confidential?

x wrote:
Jeff Moden wrote:
x wrote:
Jeff Moden wrote:
x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and 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)

August 28, 2019 at 9:42 pm

#3675221
Reply To: Tempdb Datafile initial space increasing.

Be careful now... if you do any work with SET IDENTITY_INSERT ON, you might want to reconsider especially on later versions where they essentially made Trace Flag 1117 ALWAYS active...
--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 28, 2019 at 9:38 pm

#3675219
Reply To: Index and fragmentation

Here's a presentation by Paul Randal on the subject. He's the guy that wrote most of the fragmentation related stuff.
https://www.youtube.com/watch?v=p3SXxclj_vg
--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 28, 2019 at 9:03 pm

#3675204
Reply To: Should Salary Information Be Confidential?

x wrote:
Jeff Moden wrote:
x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other...
--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 28, 2019 at 1:47 pm

#3675071
Reply To: Should Salary Information Be Confidential?

x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other hand, we...
--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 28, 2019 at 12:49 pm

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

Ray K wrote:
Had a very pleasant surprise on Saturday!!!
I spoke in Providence on Saturday. Among my audience were these two gentlemen, one of whom was Jeff Moden. (Hi, Jeff! Good...
--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 28, 2019 at 12:44 pm

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

Beatrix Kiddo wrote:
Grant Fritchey wrote:
Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index 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)

August 28, 2019 at 12:41 pm

#3675032
Reply To: Dynamically concatenate string

Whatever method you're trying, you're probably running into problems because you've defined the [FileName] column as a CHAR(400). For the value of "ABC", that means the row contains "ABC" followed...
--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 28, 2019 at 5:19 am

#3674939
Reply To: Should Salary Information Be Confidential?

Lynn Pettis wrote:
x wrote:
Lynn Pettis wrote:
x wrote:
Lynn Pettis wrote:
x wrote:
Jeff Moden wrote:
Eric M Russell wrote:
If you are an employee of the US federal government, then your salary history is public information.
Search Federal Employee Salaries
https://www.fedsdatacenter.com
7,040,119 entries
Heh......
--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 27, 2019 at 9:46 pm

#3674876

Viewing 15 posts - 8,761 through 8,775 (of 59,091 total)