blog.sqlauthority.com 2021-03-01 08:30 SQL SERVER – Speed Up Index Rebuild with SORT IN TEMPDB During the recent Comprehensive Database Performance Health Check my client... blog.sqlauthority.com 2021-02-23 08:30 SQL SERVER – Fix: There is already an object named ‘MyFirstTable’ in the database Recently I had a very interesting scenario with a client when they faced an... blog.sqlauthority.com 2021-02-22 08:30 SQL SERVER – Convert Date Time AT TIME ZONE I received an interesting question from my client last week about Comprehensive Database Performance Health Check. The question was how to... blog.sqlauthority.com 2021-02-16 08:30 SQL SERVER – STRING_ESCAPE() for JSON – String Escape Just another day a client of Comprehensive Database Performance Health Check,... blog.sqlauthority.com 2021-02-15 08:30 Forwarded Records and Performance – SQL in Sixty Seconds #155 Earlier I wrote a blog post on Forwarded Records and Performance and lots of...
blog.sqlauthority.com 2021-02-12 08:30 SQL SERVER – List Tables with Size and Row Counts What defines a table as a huge table, is it row count or size of the table? Well, during Comprehensive Database Performance Health Check I often want to know both the database which I am tuning. Today we will see a very...
blog.sqlauthority.com 2021-02-10 08:30 SQL SERVER – Check Backup Reliability Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability. Well, honestly, yes there is a way and that is to restore the...
blog.sqlauthority.com 2021-02-09 08:30 SQL SERVER – Finding Fragmentation in Forwarded Records During the recent SQL Server Comprehensive Database Performance Health Check, I was asked by my client if there any way to know if there is any way of Finding Fragmentation in Forwarded Records. Yes, there is a way to...
blog.sqlauthority.com 2021-02-08 08:30 SQL SERVER – Who Dropped Table? Part 2 I have received a lot of email as a follow-up email of Who Dropped Your Table? – SQL in Sixty Seconds #112. Many wanted to know if there is any workaround available where at least we can get some information. Of...
blog.sqlauthority.com 2021-02-03 08:30 Hide Code in SSMS – SQL in Sixty Seconds #154 I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Well, as many of you asked for me including a few of my clients of Comprehensive Database Performance...
blog.sqlauthority.com 2021-02-02 08:30 SQL SERVER – Hide Code in SSMS Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS. Well, let us learn it in today’s blog post. I often discuss this during my...
blog.sqlauthority.com 2021-02-01 08:30 SQL SERVER – CHECK CONSTRAINT to Allow Only Digits in Column Today we will see a very simple script that I recently implemented for a column for my client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in...
blog.sqlauthority.com 2021-01-28 08:30 Transfer Schema of Table – SQL in Sixty Seconds #152 Earlier I wrote a blog post about SQL SERVER – Move a Table From One Schema to Another Schema, which was based on a real client question about how to move the table from one schema to another schema. I really enjoy...
thedatabasewhisperer 2021-01-26 23:10 Avoid This Pitfall When Using sp_getapplock Takeaway: For most use cases, using sp_releaseapplock is unnecessary. Especially when using @LockOwner = 'Transaction (which is the default). The procedure sp_getapplock is a system stored procedure that can be helpful...
blog.sqlauthority.com 2021-01-22 08:30 Transactions and Variables – SQL in Sixty Seconds #150 Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today. Here is the previous video which I have done on the transaction of the Possible to...
blog.sqlauthority.com 2021-01-20 08:30 SQL SERVER – Datatype Decimal Explained – Datatype Numeric Just the other day I received an email from a client who was confused about the Datatype Decimal. Let us learn today how it works in this quick blog. First of all, lots of people think that Datatype Decimal and Datatype...
blog.sqlauthority.com 2021-01-19 08:30 SQL SERVER – Two Advantages of Sort in TempDB Options Just another day a client of Comprehensive Database Performance Health Check asked me why I suggest enabling Sort in TempDB Options for creating and rebuilding indexes. Let us discover two advantages of the...
blog.sqlauthority.com 2021-01-15 08:30 SQL SERVER Management Studio – Grid vs Text Output Recently, I had an interesting situation where my client was inserting multiple texts in their text column but their output was always in a straight line. During the Comprehensive Database Performance Health Check, they...
blog.sqlauthority.com 2021-01-14 08:30 SQL SERVER – Move a Table From One Schema to Another Schema Just another day, I have received an email from a regular client of Comprehensive Database Performance Health Check. My client wanted to learn the trick to Move a Table From One Schema to Another Schema. Let us learn it...
blog.sqlauthority.com 2021-01-13 08:30 SQL SERVER – List All Dates Between Start and End Date Today we will see a very simple script where we will take advantage of the Common Table Expression (or CTE) and list all dates between two dates (Start and End Date). The script is very simple and lets us see it here...
blog.sqlauthority.com 2021-01-12 08:30 Count Table in Cache – SQL in Sixty Seconds #149 Earlier I had written a blog post about SQL SERVER – Find Count of Table Used in Query From Cache. Lots of people asked me to create a SQL in Sixty Seconds of videos from it. I decided to accept the request and today...
blog.sqlauthority.com 2021-01-11 08:30 SQL SERVER – Compression Delay for Columnstore Index Today we will talk about the Compression Delay for Columnstore Index which I got first-hand experience with my client of Comprehensive Database Performance Health Check. Root Cause of Issue One of my clients who has...
thedatabasewhisperer 2021-01-09 00:48 Collect Wait Stats Regularly in Order To Report On Them Over Time I find wait stats so useful that I’ve got Paul Randal’s SQL Server Wait Statistics (or please tell me where it hurts…) bookmarked and I visit it frequently. But that gives the total amount of waits for each wait...
blog.sqlauthority.com 2021-01-08 08:30 SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL What we are going to discuss in today’s blog post is not something I do every day at the Comprehensive Database Performance Health Check. Today’s topic is very unique and one should not try it out without the proper...
blog.sqlauthority.com 2021-01-07 08:30 SQL SERVER – Columnstore Index and Fragementation One of the questions I had received from a client was about how to find out fragmentation in columnstore index. They asked me this question while we were working together on a Comprehensive Database Performance Health...
