Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,636 through 16,650 (of 59,101 total)

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

PearlJammer1 (10/17/2016)
What has happened (and I don't yet fully understand why but will discuss with our dev team) is that for example, we have an ID field on a table...
--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 6:31 pm

#1907037
RE: Using SP in UDF

Alaster07 (10/14/2016)
I understand that an iTVF is better; however, I have no experience using them. I have read about them and attempted to implement it, but it was 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)

October 17, 2016 at 11:12 am

#1906940
RE: Please up vote on Connect Item 2558789

Beatrix Kiddo (10/17/2016)
sqladdict (10/17/2016)
They better not deprecate SSMS! Visual Studio just won't cut it.
Agreed!
If they ever did retire it, so would I. Retire, that 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)

October 17, 2016 at 9:44 am

#1906922
RE: Dynamically checking for columns and update

hegdesuchi (10/17/2016)
thank you very much!
How can i achieve that using except clause?
EXCEPT will only produce a list of rows that aren't the same. Sure, it's a good start but...
--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:31 am

#1906920
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

Viewing 15 posts - 16,636 through 16,650 (of 59,101 total)