Viewing 15 posts - 1 through 15 (of 212 total)
I totally agree with you that a lot of half full pages is bad for disk storage, memory consumption and reading a lot of extra pages due to the low...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 26, 2020 at 3:21 pm
Thank you for pointing this out to anyone! Optimizing queries and keep your statistics up to date is far more efficient for the performance. The impact of fragmentation is even...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 25, 2020 at 9:38 am
That was an easy question. You can have different compression levels for different partitions of an index and thats why you need to look at sys.partitions. You can also find...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 25, 2020 at 8:35 am
Tricky! I guessed 3, estimated, actual and live
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 17, 2020 at 9:44 am
That was interesting!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 4, 2020 at 7:05 pm
That one was too easy, I almost thought it was a trick question
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 4, 2020 at 6:35 pm
I have never used Python, but this seems to be a nice feature.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 21, 2020 at 7:06 am
I also stuck with the answers about the products, as the query had nothing to do with products. I then assumed there has to be some issues in the query...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 15, 2020 at 11:25 am
Thanks for the Question! That was unexpected.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 13, 2020 at 8:05 am
Easy question. If you delete the login you can get some problems because the owner doesn't exist anymore. Thats why it is imortant to change the owner.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 10, 2020 at 6:01 am
I only get the A in the grid, but A B C D E F in text result. Strange.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 3, 2018 at 9:05 am
One problem with EOMONTH is that it doesn't return the time, and if you convert the date to datetime, you will not get the end of month as the time...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 2, 2017 at 7:19 am
This is a very useful setting!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
May 16, 2017 at 3:53 pm
As already answered, sysdatabases are for backward compatibility, but instead of creating your own script for re-indexing, you should consider using the Ola Hallengren maintenance solution. Read more at /Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 28, 2017 at 3:00 am
I almost got it wrong as I didn't see the comma first and got confused so I had to read the options twice. Sometimes the devil is in the details.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 28, 2017 at 2:44 am
Viewing 15 posts - 1 through 15 (of 212 total)