Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,416 through 8,430 (of 59,072 total)

Reply To: Using OFFSET for Paging

peter.row wrote:
We will soon be able to drop support for SQL 2008R2 from our product making SQL 2014 the minimum...
I strongly recommend that you upgrade that to the latest 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)

November 4, 2019 at 1:24 pm

#3694296
Reply To: The Top Ten Percent

I wonder why you specifically mentioned 2017. It works the same in all versions from 2005 and up.
--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)

November 4, 2019 at 4:19 am

#3694182
Reply To: SQL Compression

GrassHopper wrote:
I have a database with no compression on the tables(source). I want to create a blank database(destination) where I can create the tables with "data_compression = Page" 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)

November 4, 2019 at 3:37 am

#3694177
Reply To: Jr vs Sr Developer

CoolKid40 wrote:
Whats diff of job tasks between junior developer and senior sql developer u all would say? Thanks
Thom is mostly right in that "It Depends" on the company but let...
--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)

November 3, 2019 at 5:56 pm

#3694151
Reply To: Linking to SQL Server in one domain from a different domain works but...

as_1234 wrote:
Could it be something in the firewall between the zones? Maybe a max connection time? Or perhaps, for some reason, it's seeing the connection as idle and dropping it?
Sorry...
--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)

November 3, 2019 at 4:47 pm

#3694147
Reply To: Run query across 100\'s of servers in 1 go to set up a process

Jeff Moden wrote:
mtz676 wrote:
Awesome Jeff Moden...but not enough ....I did not know I could post here and also expect an answer and then give it back to the interviewer all 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)

November 3, 2019 at 4:08 pm

#3694142
Reply To: Oops, I deleted that data

p.s. Also, remember that the answer is always "No" unless you ask. If you don't have an "IN" with the infrastructure team or the people holding the purse, also remember...
--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)

November 3, 2019 at 3:39 pm

#3694141
Reply To: Oops, I deleted that data

MVDBA (Mike Vessey) wrote:
The best thing we ever invested in is Our DR test server - regular automated restore tests and also re-usable as a data playpen - i'm hoping to get...
--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)

November 3, 2019 at 3:37 pm

#3694140
Reply To: Oops, I deleted that data

jermitts 57867 wrote:
Table triggers will kill your performance and are generally frowned upon. If your database is small and your users are few it won't matter, but this isn't a scalable...
--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)

November 3, 2019 at 3:01 pm

#3694136
Reply To: Run query across 100\'s of servers in 1 go to set up a process

mtz676 wrote:
Awesome Jeff Moden...but not enough ....I did not know I could post here and also expect an answer and then give it back to the interviewer all at 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)

November 3, 2019 at 2:44 pm

#3694134
Reply To: ETL for 4 Databases into a Single Distributed database

My apologies. I normally don't associate the term "ETL" with moving data between databases even when one may be a source and another is a data warehouse. I normally associate...
--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)

November 3, 2019 at 3:10 am

#3694121
Reply To: ETL for 4 Databases into a Single Distributed database

SQLDude wrote:
Thank you for the response. So basically I can create a .NET application to provide additional functionality, but reading headers and splitting as you’ve suggested . Then I can...
--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)

November 3, 2019 at 2:02 am

#3694119
Reply To: Run query across 100\'s of servers in 1 go to set up a process

Let's do the math here... you say "100's of servers". If each server only had 4 core, and "100's of servers" meant at least 200, that would be 800 core. ...
--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)

November 3, 2019 at 1:51 am

#3694118
Reply To: ETL for 4 Databases into a Single Distributed database

So read the header row from your data, split it, and compare it to your table columns. If they're not named the same, then you'll need a mapping table 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)

November 3, 2019 at 1:36 am

#3694116
Reply To: last day of the month minus 1 day

The cool part about threads like this is that no one is actually incorrect. There are pros and cons on both sides and it might even be appropriate to use...
--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)

November 2, 2019 at 7:12 pm

#3694097

Viewing 15 posts - 8,416 through 8,430 (of 59,072 total)