Viewing 15 posts - 1,006 through 1,020 (of 59,060 total)
Jeff, I've taken your suggestion. I didn't migrate one of our databases to Azure. Instead, I created an Azure SQL database using one of the AdventureWorks databases. It's small,...
October 11, 2023 at 3:37 am
It sounds to me like someone may have tried to move the database files and failed to do it correctly. The MDF file may still exist someone on one of...
October 10, 2023 at 5:46 pm
Well i think its increase both log and mdf/ndf files of tempdb .How to get size of temp table ?
For the first statement, you don't actually know if that's...
October 9, 2023 at 11:01 pm
"A confident person often convinces others that they're right, by sheer force of will."
Ooooo maaannnn... you hit a real "hot spot" there for me.
One of my favorite examples is...
October 9, 2023 at 9:36 pm
I seriously agree about the ISO thing. It's a real shame that MS hasn't made a few more built in functions around ISO Week and Year.
I advise caution when using...
October 9, 2023 at 9:07 pm
Does it recommend against using '--' as comment delimiters 😛
But seriously, good luck on this, Steve.
Steve didn't write it. His name shows up here because he's the person that...
October 7, 2023 at 6:05 pm
Thank you All.
Two way street here, Sam. You've not answered my question above. Why is someone trying to Truncate a table while others are trying to SELECT...
October 5, 2023 at 12:05 am
I'm not sure that I'd mess with BLOCKSIZE but I definitely agree with experimenting to find the best MAXTRANSFERSIZE and the BUFFERCOUNT.
BLOCKSIZE makes a big difference when backing up...
October 4, 2023 at 6:38 pm
Hm. Some of our databases are 20Tb. Total 80Tb on one server, takes more than a day for full backup.
How many backup files are you creating with these...
October 4, 2023 at 6:04 pm
Hello,
I have come across this peculiar problem.
This stp is called every begin of the day of the application startup. A bug got introduced in the stp.
The BEGIN TRAN was...
October 4, 2023 at 6:01 pm
I'm curious as to what measurable benefit you realized from performing reindexing / reorg on your indexes?
😉
October 4, 2023 at 5:57 pm
Perhaps you could create a view with the columns in your (client's) preferred order? It it was a full view, it should be updatable and therefore the view name...
October 4, 2023 at 5:54 pm
Thank you All.
Two way street here, Sam. You've not answered my question above. Why is someone trying to Truncate a table while others are trying to SELECT from it? ...
October 4, 2023 at 2:51 pm
Is there a way to reorganise the fields into alphabetical order without creating a new table and transferring all the data?
That is, quite possibly, the worst table design idea...
October 4, 2023 at 2:49 pm
Heh... Ok! The OP has left the building!
October 4, 2023 at 2:07 pm
Viewing 15 posts - 1,006 through 1,020 (of 59,060 total)