Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 59,086 total)

Reply To:

wrote:
Does anyone know any good database archive software/tools out there?
We are looking into a tool that will archive data off of the OLTP databases into an archive database. 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)

July 20, 2022 at 2:04 pm

#4066001
Reply To: Scanning on different Index

What is the datatype of @P8? If it's not NVARCHAR(), it will ALWAYS do an index SCAN because it first has to convert all of the rows in the entire...
--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)

July 20, 2022 at 1:58 pm

#4065971
Reply To: Parsing a lange XML data-column from one server to another

Just an opinion but using XML to transfer data between servers seems counter productive to me. Instead, I'd have a common area that all the servers could write to 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)

July 19, 2022 at 3:12 pm

#4065357
Reply To: The Limited Cloud

You also have to remember about licensing of SQL Server on spin-ups. I've never seen anything written about that but, disclaimer, I've not looked for such a thing. I only...
--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)

July 19, 2022 at 3:01 pm

#4065355
Reply To: Slow performance after the upgrade

Chitown wrote:
After changing just the compatibility level, queries are running efficiently. Thanks all...
That also means that you may be missing out on some newer technology in the database engine. It...
--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)

July 19, 2022 at 2:51 pm

#4065350
Reply To: Parse SQL data

Steve Collins wrote:
To split out the pd_id's you could try STRING_SPLIT to separate based on space delimiter. Since some 'PD-[0-9]' values are encompassed by other extra characters a conditional substring 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)

July 19, 2022 at 2:58 am

#4065077
Reply To: how to call a scalar function without schema in sqlserver 2019

rajemessage 14195 wrote:
i understood in case of storedporcedure , but in case of the function.
I logged in using the user "login s2" then executed the function "s1.xyz" which is in schema...
--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)

July 17, 2022 at 9:46 pm

#4064528
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Question for the smart people, and the rest of you.
Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.
Or 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)

July 17, 2022 at 5:51 pm

#4064496
Reply To: Merge Replication or Back up and Restore

p.s. There's no way that I'd take all the time to upgrade 2012 to 2019. 2019 is already 3 years old and 2022 has some fairly handy new things 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)

July 17, 2022 at 4:14 pm

#4064482
Reply To: Web site font colour/background colour and readability

It's not just a lack of contrast... most of them are terrible for color, font, usability, etc. Seems like most have gone "metro" and, to me, "metro" is seriously uninspired...
--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)

July 17, 2022 at 7:09 am

#4064382
Reply To: Merge Replication or Back up and Restore

Write a stored procedure to do the restore and schedule it as a job?
--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)

July 17, 2022 at 12:35 am

#4064329
Reply To: Going after my MCSA SQL Server 2016 and need MOC recommendations.

Grant Fritchey wrote:
If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online,...
--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)

July 16, 2022 at 2:53 am

#4064065
Reply To: While Loop Data Issue

Ok... in your last post at https://www.sqlservercentral.com/forums/topic/how-to-get-last-5-weeks-start-and-end-dates you wanted the weeks to be calculated based on whatever GETDATE() returned and you used the example of what you wanted on...
--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)

July 16, 2022 at 2:22 am

#4064062
Reply To: Calendar table in SQL

You bet. Thank you for the feedback, Pedro.
--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)

July 15, 2022 at 8:55 pm

#4063993
Reply To: Calendar table in SQL

Shifting gears a bit, I remembered that I had refactored Peter's good code and found it in my archives. I redacted that to have a nice flower box and included...
--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)

July 15, 2022 at 5:18 pm

#4063917

Viewing 15 posts - 3,166 through 3,180 (of 59,086 total)