Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]
2019-08-27
3,415 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
5,708 reads
Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
2019-02-25
3,023 reads
2010-12-16
11,606 reads
UPDATE [RiskSysSum of Source ClaimType] SET FinLagCatagory = (CASE WHEN ClaimType IN ('OP','SPU') THEN 'OP/SPU' WHEN ClaimType IN ('SNF','RHB') THEN 'SUBACUTE' WHEN ClaimType IN ('PCP', 'PH', 'SP', 'SPI', 'SPO') THEN 'Spec' WHEN ClaimType IN ('IP', 'SBC', 'SC') THEN 'IP' WHEN ClaimType IN ('EM', 'ER') THEN 'EREM' WHEN ClaimType IN ('DME', 'HC', 'OTA', 'TSP', '') THEN […]
2005-05-20
Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands. You can also just run sp_who2 from QA and avoid running this in EM. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-08
Yes, it does mean every user will be kicked out of the database. The reson behind this is that SQL Server needs to have complete control over the db before it can restore it. Work like you don't need the money. Love like you've never been hurt. And Dance like no one is watching.
2003-07-16
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers