Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,266 through 8,280 (of 59,072 total)

Reply To: How Do You Act When You Need to Learn New Technology?

MVDBA (Mike Vessey) wrote:
I've tried getting service broker, hierarchyid, graph and many other things... nobody wants to step out of their comfort zones.
What did you want folks to use HierarchyID and Graph...
--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 27, 2019 at 9:25 pm

#3701670
Reply To: How to backup the Xmldata table in sql server 2016

polo.csit wrote:
Database is full recovery model.when copy the table in single table also take time more and copy of the table is INTO statement.
We keep going in circles. I already...
--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 27, 2019 at 3:32 pm

#3701582
Reply To: SQL Cursor Trouble

To the best of my recollection (yeah, I was working with unit record equipment and computers way back then), the only "NULL" value on punch cards was to simply not...
--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 27, 2019 at 3:16 pm

#3701575
Reply To: Need to find out what combination of columns makes each record in table unique

It's difficult for me to believe that such a table exists and no one knows anything about it. Find who does and ask them.

--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 27, 2019 at 2:10 pm

#3701541
Reply To: Need to find out what combination of columns makes each record in table unique

Have you asked anyone???

--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 27, 2019 at 2:53 am

#3701300
Reply To: Whose account the job runs under?

sqlfriend wrote:
Thanks, figured out the access issue
Two way street here... what was the solution that you figured out?
--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 27, 2019 at 2:24 am

#3701297
Reply To: Sort is taking time in execution plan

IMary wrote:
Hi,
I have a strange situation where SORT operator is taking 10 sec in prod database and when run the same query in Test SQL instanceI'm not seeing that SORT...
--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 27, 2019 at 2:23 am

#3701296
Reply To: How to backup the Xmldata table in sql server 2016

jonas.gunnarsson 52434 wrote:
Your backup, to a table in same database, is it for migration/upgrade purposes?
(If so, maybe set database to single user mode, first.)
Otherwise is it possible to use the builtin...
--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 27, 2019 at 1:42 am

#3701289
Reply To: How to backup the Xmldata table in sql server 2016

polo.csit wrote:
created new database it is also take time more....
Maybe the way you're doing it. Answer my previous question, please. You'll be amazed at how fast we can make stuff. ...
--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 27, 2019 at 1:39 am

#3701288
Reply To: Temporal tables -- reasons not to use them?

Steve Collins wrote:
Jeff Moden wrote:
I'm pretty sure that the system times captured by temporal tables are in the DATETIME2(7) level of precision. What else would you need?
Yea right, it's super precise so...
--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 26, 2019 at 9:56 pm

#3701256
Reply To: SQL Cursor Trouble

jcelko212 32090 wrote:
We need to correct your attempt at DDL. By definition, a table must have a key, but this is impossible with your DDL because both columns are NULL 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)

November 26, 2019 at 9:39 pm

#3701255
Reply To: SQL Cursor Trouble

drew.allen wrote:
Jeff Moden wrote:
drew.allen wrote:
No solution is going to work here, because all solutions require a sort and there was no field provided that would ensure the correct sort.
This was 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 26, 2019 at 9:33 pm

#3701250
Reply To: Temporal tables -- reasons not to use them?

Steve Collins wrote:
In the project I'm working on we're about to implement 4 temporal tables in Azure SQL. In the past I've worked with version tracking using guids and triggers. 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 26, 2019 at 9:09 pm

#3701233
Reply To: SQL Cursor Trouble

drew.allen wrote:
No solution is going to work here, because all solutions require a sort and there was no field provided that would ensure the correct sort.
This was and still 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)

November 26, 2019 at 8:13 pm

#3701220
Reply To: How Bad are Bad Page Splits?

Mike Byrd wrote:
All of ya’lls comments are absolutely correct. Not sure where my brain was when I wrote the original paragraph, but obviously not in this universe. This is 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)

November 26, 2019 at 6:23 pm

#3701184

Viewing 15 posts - 8,266 through 8,280 (of 59,072 total)