Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 59,091 total)

Reply To: Creating a DB

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. ...
--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)

June 6, 2020 at 7:11 pm

#3761094
Reply To: performance tuning for a subquery

Just to confirm, COALESCE won't provide an improvement in performance over CASE, although it will make the code a whole lot easier. Behind the scenes, the optimizer converts a COALESCE...
--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)

June 6, 2020 at 3:20 pm

#3761070
Reply To: Creating a DB

Jeffrey Williams wrote:
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. It 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)

June 6, 2020 at 2:57 pm

#3761068
Reply To: Covert a string to simple sql datetime format
Jonathan AC Roberts wrote:
DECLARE @DateString nvarchar(100)='Wed Jun 29 15:57:45 2019'
SELECT CONVERT(datetime,SUBSTRING(@DateString,5,100))
I've always been astounded by the implicit conversions of strings to DateTime that SQL Server handles correctly. It seriously...
--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)
June 6, 2020 at 2:08 pm

#3761059
Reply To: Sql to oracle replication

frederico_fonseca wrote:
CDC can be used in AWS RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html
but CDC does not push anything - just helps a ETL job to identify what has changed.
Got it. Thank you, good...
--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)

June 5, 2020 at 10:45 pm

#3760991
Reply To: Dynamic SQL (openrowset) problem

as_1234 wrote:
Sorry I should have been more detailed in my question. The variable is the collection variable for a foreach loop which is looping through the files in a folder....
--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)

June 5, 2020 at 10:06 pm

#3760990
Reply To: Creating a DB

Post withdrawn.

--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)

June 5, 2020 at 9:45 pm

#3760981
Reply To: Physical db changes stored in transaction log file?

I treat my Dev servers exactly the same as my Prod servers when it comes to backups and transaction logs and recovery models. It's has saved dozens of days of...
--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)

June 5, 2020 at 6:29 pm

#3760935
Reply To: Dynamic SQL (openrowset) problem

as_1234 wrote:
The eventual plan is that @Filename will be the parameter in an SSIS package so I don't think there is any risk of SQL injection through the use of...
--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)

June 5, 2020 at 5:51 pm

#3760930
Reply To: Sql to oracle replication

frederico_fonseca wrote:
Admingod wrote:
Thanks! Has anyone has any thoughts on Change Data Capture. The CDC function is, probably similar to the transactional replication. It is not the same, but it has...
--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)

June 5, 2020 at 5:44 pm

#3760926
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

heiko3169 wrote:
If you use it right, EF is fine.
Now THAT I'll mostly agree with. The key is getting people to "use it right". For example, at one company I do...
--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)

June 5, 2020 at 5:31 pm

#3760920
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

heiko3169 wrote:
hamishdmccreight wrote:
[...]
Entity Framework is a bit fat wrapper around ADO and it took Microsoft about seven releases to get something that was relatively stable. It is essentially another...
--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)

June 5, 2020 at 5:21 pm

#3760917
Reply To: Integer convert to percent

Mr. Brian Gale wrote:
I'd recommend against implicit conversions wherever possible. There are a lot of articles online about implicit conversion and even SQL Server, via the execution plan, will give a warning...
--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)

June 5, 2020 at 4:36 pm

#3760903
Reply To: Integer convert to percent

williamskevinjames wrote:
An alternative is to use the format function to convert it to a percentage. Note that I'm only casting the FirstInteger to a decimal(18,10) because the SecondInteger is implicitly...
--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)

June 5, 2020 at 3:21 pm

#3760882
Reply To: 3 Things I Wish I Knew When I Started Using Entity Framework

My biggest gripe about ORMs, especially old Linq To SQL (but not limited to that one), is datatype mismatches where the passed variables are NVARCHAR() as criteria to be played...
--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)

June 5, 2020 at 2:15 pm

#3760864

Viewing 15 posts - 6,961 through 6,975 (of 59,091 total)