Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,311 through 8,325 (of 59,091 total)

Reply To: Future Proof

I'll be the first to admit that I'm a bit of a T-SQL zealot when it comes to doing things with data. A part of the reason is that I've...
--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 24, 2019 at 7:01 pm

#3700333
Reply To: look for the most efficient method

to go along with what the other folks have written...
The biggest difference is that it will not be possible to get index seeks on the 3 column index if 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 23, 2019 at 3:08 am

#3700193
Reply To: One machine is not able to connect to sql server while others connect fine

We had that happen to us the other day... exact same symptoms. It turned out to be a cable where a partial connection in an RJ-45 jack finally backed 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 23, 2019 at 2:16 am

#3700190
Reply To: Previous Day (Business Day Only) Needed for Auto Tableau Server Script

What's really stupid is that Jonathan is absolutely correct (and, NO, I'm NOT saying Jonathan is stupid... Jonathan is far from stupid and only occasionally resorts to RBAR :D...
--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 23, 2019 at 1:50 am

#3700185
Reply To: DR Priority

I guess I'm different... perhaps, a lot different. AG is nice and all but, to me, AG has NOTHING to do with DR and vice versa. To me, DR 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 23, 2019 at 1:25 am

#3700175
Reply To: how to lock the record

Steve Collins wrote:
What Jeff wrote is enough to scare me away from even trying this approach. Using internal locking could enable end-users to do things which produce unpredictable performance. You wrote...
--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 22, 2019 at 1:48 pm

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

Can the database be set to the BULK LOGGED recovery model? If not, can we put this table in a new, single table database that can?
Also, how up to date...
--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 22, 2019 at 1:00 pm

#3699986
Reply To: how to lock the record
KGJ-Dev wrote:
Hello,
i have a table called Codes and having below columns
```
Declare table Codes(IdCode int identity(1,1) primary key, EmpCode varchar(10) unique key, AllotedStatus bit default 0)
```
i will 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 22, 2019 at 12:56 pm

#3699983
Reply To: error trying to create another log file

Do you actually have 65GB remaining on the drive to create the file? And, I've got to ask, are you sure the path is correct?
--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 22, 2019 at 12:46 pm

#3699982
Reply To: Previous Day (Business Day Only) Needed for Auto Tableau Server Script

John Mitchell-245523 wrote:
Yes, or WHERE CAST(CLOG.RecvdDate AS date) = '20191120'. I think casting as date preserves sargability (provided that the column is datetime in the first place).
John
It does and it's better...
--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 22, 2019 at 12:33 pm

#3699978
Reply To: Query tuning of SELECT

Have you considered just rebuilding the heap? You should also rebuild any non-clustered indexes, as well, to recover space and rebuild stats.

--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 22, 2019 at 4:02 am

#3699869
Reply To: how to create triggers with delete and update
mcfarlandparkway wrote:
if all 4 columns data exists already and the new data matched with exisitng it shoudl delete using trigger.
There's a little bit of ambiguity in that statement. Delete from...
- This reply was modified 6 years, 9 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)
November 22, 2019 at 3:39 am

#3699867
Reply To: Row_Number for grouping to find min and max values

It would be nice if you provided the CREATE TABLE statment to go along with the test data. Posting the code for your attempt would probably help, as well.,
--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 22, 2019 at 3:33 am

#3699866
Reply To: need help with a query to avoid while loop

jcelko212 32090 wrote:
Never, never use that highly proprietary and totally nonrelational SQL_variant data type.
You really need to come out of your shell on SQL, Joe. While I agree that 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 22, 2019 at 3:23 am

#3699863
Reply To: how to lock the record

ScottPletcher wrote:
Indirectly, yes there is, and it's a guaranteed locking approach, since it's provided by the db engine itself, and uses its own locking mechanisms internally.
Use system procs sys.sp_getapplock 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 22, 2019 at 2:18 am

#3699862

Viewing 15 posts - 8,311 through 8,325 (of 59,091 total)