Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,606 through 16,620 (of 59,067 total)

RE: Dynamically checking for columns and update

drew.allen (10/17/2016)
Your client doesn't know what he is talking about
Careful now... if there are column-based audit or alert triggers on the table, then the client DOES know what they're talking...
--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)

October 17, 2016 at 9:23 am

#1906918
RE: Differential backup too big

Was the TR and CDC in place for a good period of time before the large DIF problem occurred?
--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)

October 17, 2016 at 9:18 am

#1906912
RE: The Attribute

Iulian -207023 (10/17/2016)
Jeff Moden (10/17/2016)
My answer would be "None of the above" because I don't want people to store XML in the database. 😉
Well ... there is also 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)

October 17, 2016 at 9:15 am

#1906910
RE: The Attribute

My answer would be "None of the above" because I don't want people to store XML in the database. 😉
--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)

October 17, 2016 at 8:55 am

#1906898
RE: Default trace consuming too much IO

yo.mawtin (10/17/2016)
Resource Monitor tells me that sqlservr.exe is continuously reading about 1,200,000 B/sec from log_636.trc. Seems crazy. It's something like 10x - 100x what other IO operations do. I believe...
--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)

October 17, 2016 at 8:44 am

#1906893
RE: HELP! I've got to give a talk to our local .NET geek meet on SQL server

aaron.reese (10/17/2016)
When you do code-first design
Heh... "Never". 😛
--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)

October 17, 2016 at 8:42 am

#1906888
RE: Are the posted questions getting worse?

Phil Parkin (10/17/2016)
Spammers have upped their game recently. Some are starting to mention 'SQL' or 'database' in the subject line, the ****ers. What's the latest on migration to new forum...
--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)

October 17, 2016 at 8:03 am

#1906872
RE: A Load Of Old Cobols

Eric M Russell (10/17/2016)
I occasionally encounter SQL that was originally coded back in the early '90s, even though it has been migrated to newer hardware and RDMS platforms several times...
--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)

October 17, 2016 at 7:50 am

#1906863
RE: finding the current ID value compared to the IDENTITY value

PearlJammer1 (10/17/2016)
Hi Jeff
It is because we have a situation where some tables appear to have id values less than the current identity value which will get auto generated on next...
--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)

October 17, 2016 at 7:40 am

#1906860
RE: Subqueries in VALUES()

It's a bloody shame that any of them work. It's just another thing for people to mess up things with, just like many folks already do with sub-queries 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)

October 17, 2016 at 12:03 am

#1906795
RE: Please up vote on Connect Item 2558789

sqladdict (10/14/2016)
So Annoying. Please up vote to get this fixed.
https://connect.microsoft.com/SQLServer/feedback/details/2558789/ssms-march-2016-temp-files-are-in-recent-file-menu
Ships passing in the night... It was marked as "FIXED" an hour before you posted. 😉 It'll be in 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)

October 16, 2016 at 11:34 pm

#1906793
RE: Split String On Delimiter

Eirikur Eiriksson (10/15/2016)
Here is a more efficient alternative, beats the c..p out of the string splitting functions
VERY cool concept but, in this case, it appears to be coming up with...
--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)

October 16, 2016 at 11:29 pm

#1906792
RE: Naming Backup when saving to Disk with loop

The BACKUP DATABASE statement cannot be made to use variables directly. You must build it as dynamic SQL and then execute it.
Sad but true. They didn't make...
--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)

October 16, 2016 at 11:09 pm

#1906791
RE: finding the current ID value compared to the IDENTITY value

PearlJammer1 (10/14/2016)
Hi
I need to find the current identity value compared to the current column value of tables with identity fields - in particular where the current column value is less...
--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)

October 16, 2016 at 4:23 pm

#1906790
RE: Conflict in Functional Teams

David.Poole (10/13/2016)
Democracy works on the principle of opposing view points. Perhaps your greatest asset is the one that disagrees with you because you have to think to counter their...
--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)

October 16, 2016 at 4:18 pm

#1906789

Viewing 15 posts - 16,606 through 16,620 (of 59,067 total)