Viewing 15 posts - 1 through 15 (of 1,439 total)
While better than nothing, I doubt many people use maintenance plans. I use the following:
and
February 10, 2025 at 8:14 am
One solution would be to copy the data to a centralized database/warehouse and report from that.
February 4, 2025 at 2:50 pm
I have never come across this either.
The first thing I would do is run Brent Ozar's sp_blitz. As well as the health check, there are parameters which allow you...
January 9, 2025 at 2:46 pm
The simple approach would be to put your query in a CTE with
,ROW_NUMBER() OVER (PARTITION BY Model ORDER BY Cal DESC) AS rn
and then SELECT FROM the CTE WHERE rn...
January 8, 2025 at 9:59 pm
Do you have any DDL and test data to demonstate this?
January 8, 2025 at 9:53 pm
1. If RT.coloumnC etc are strings, you could try something like:
RT.coloumnC='something' COLLATE <RT.coloumnC collation>
2. If #lt is not too big, you could try creating a remote SP and passing the...
January 6, 2025 at 5:46 pm
¿Qué?
Just send an html email with the table in the body text.
December 31, 2024 at 4:19 pm
Why are you trying to install SQL Server 2005 when the lowest supported version is SQL Server 2016?
What version of Windows are you trying to install SQL 2005 on? I...
December 27, 2024 at 2:30 pm
It is the SQL Server VSS Writer service which writes details of VSS backups to MSDB so that is where to start trouble shooting. Check the service account, check the...
December 26, 2024 at 8:32 pm
The SQL Server VSS Writer service is probably disabled. It might have been disabled if it was interfering with SQL Server backups.
Before relying on someting like Veem, make sure you...
December 26, 2024 at 7:25 pm
You could generate the code as dynamic SQL to cope with different numbers but you would need to check carefully how efficient a value of 100 was.
Whatever you are trying...
December 20, 2024 at 9:18 pm
1. I hope you are not using floats for prices!
2. Do you really use reserved names for columns?
3. Are you really writing new code with the depreciated order by column...
December 20, 2024 at 12:58 pm
This smells like a permissions issue for the SP. I am not anywhere I can test this but I suspect you will need to sign the SP and then have...
December 19, 2024 at 8:31 pm
Viewing 15 posts - 1 through 15 (of 1,439 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy