SQL Authority with Pinal Dave
Channel Reputation Rank
Activity Status
Stale
last updated
Enter a key term, phrase, name or location to get a selection of only relevant news from all RSS channels.
Enter a domain's or RSS channel's URL to read their news in a convenient way and get a complete analytics on this RSS feed.
SQL SERVER – The Monthly Mentor Returns 2021
The year 2021 is bringing lots of learning opportunities and one of them is the Monthly Mentor series. I will be presenting along with Quest presentations...
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...
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...
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...
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...
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...
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...
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...
SQL SERVER – Database Giving Error While Setting Single_User Mode
Recently during the Comprehensive Database Performance Health Check, I had a very interesting situation when I had to set the database into single-user...
SQL SERVER – Checking Traceflag Status with TRACESTATUS
Today we are going to learn about a very simple and easy thing. If you are using SQL Server for a while, you may be familiar with the concept of trace...
SQL SERVER – Find Count of Table Used in Query From Cache
Recently during Comprehensive Database Performance Health Check, we had an interesting situation where we wanted to Find the Count of Table Used in Query...
Unfortunately SQL Authority with Pinal Dave has no news yet.
But you may check out related channels listed below.
Developer – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part ...
[...] check out the first chapter for free here.) Tip #1: Start and maintain a highly focused blog Pinal Dave has done an excellent job of this and he is reaping the benefits. Do you think Pinal Dave would [...]
SQL SERVER – Reverse String Word By Word – Part 3
[...] , you can convert this script to function afterwards. DECLARE @ip VARCHAR (8000) = 'My Name is Pinal Dave'; WITH cteSplit AS ( SELECT SUBSTRING (@ip, num, CHARINDEX (' ', @ip + ' ', num) - num) AS [ [...]
SQL SERVER – Reverse String Word By Word
[...] @ip = '' END END RETURN @op END -- Usage SELECT [dbo].[fn_ReverseWordsInSentence] ('My Name is Pinal Dave') /* Dave Pinal is Name My */ Let me know if you have a better way to solve this problem. [...]
SQL SERVER – Reverse String Word By Word – Part 4
[...] @slice VARCHAR(8000) DECLARE @rtnString NVARCHAR(50) SET @Delimiter = ' ' SET @String = 'I am Pinal Dave' SET @rtnString = '' SET @count = 1 WHILE @count > 0 BEGIN SET @count = CHARINDEX(@ [...]
Hey DBA – Baselines and Performance Monitoring – Why? – Notes from the Field #05...
[...] question. Read the entire story in his own words. Last time it was my time to post here on SQL Authority, I suggested that DBAs make a proactive investment in their environments. I can’t stress this [...]
SQL SERVER – Watching Table Variable Data in TempDB
[...] this? Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: MySQL, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup fo...
[...] values. Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – Error: Msg 701, Level 17, State 103. There is insufficient system m...
[...] such topics. Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied...
[...] .com) Filed under: PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – Configuration and Performance of SQL Server is Now Easy to Master
[...] .com) Filed under: PostADay, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Confio, Solarwind [...]
Interview Question of the Week #004 – List All Columns and Their Data Type for a...
[...] under: PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – How to Bind Resource Governor for InMemory Enabled Databases?
[...] (http://blog.sqlauthority.com) Filed under: PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Resource Governor [...]
SQL SERVER – FIX – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a c...
[...] PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Powershell [...]
SQL SERVER – Backups are Non-negotiable Lifeline for DBAs
[...] .com) Filed under: PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Idera [...]
SQL SERVER – What is the query used in sp_cursorfetch and FETCH API_CURSOR?
[...] under: PostADay, SQL, SQL Authority, SQL Cursor, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: cursor [...]
SQL SERVER – Visibility into the Overall Health of Your SQL Server Environment –...
[...] .com) Filed under: PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Dell [...]
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state th...
[...] Reference: Pinal Dave (http://blog.sqlauthority.com) Filed under: PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, T SQL [...]
SQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056
[...] (http://blog.sqlauthority.com) Filed under: Notes from the Field, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: Azure [...]
SQL SERVER – The Basics of the SSIS Data Flow Task – Notes from the Field #057
[...] (http://blog.sqlauthority.com) Filed under: Notes from the Field, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, T SQL Tagged: SSIS [...]
SQL SERVER – Beginning with SQL Server Security Aspects
[...] server roles) Database level (database users, DB and application roles) There are two SQL Server authentication types: by using Windows account security token by using an account defined inside SQL [...]
SQL SERVER – Beginning with SQL Server Security Aspects
[...] server roles) Database level (database users, DB and application roles) There are two SQL Server authentication types: by using Windows account security token by using an account defined inside SQL [...]
SQL SERVER – Proving that the Source of the Problems aren’t Tied to the Database
[...] (physical configuration), they used an 8 Processor machine for the application’s database server. As part of the consolidation, the network team accidentally made it a single CPU machine and [...]
SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Sea...
[...] attending this session, developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the [...]
SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando –...
[...] attending this session, developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the [...]
Developer – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part ...
[...] check out the first chapter for free here.) Tip #1: Start and maintain a highly focused blog Pinal Dave has done an excellent job of this and he is reaping the benefits. Do you think Pinal Dave would [...]
SQL SERVER – Reverse String Word By Word – Part 3
[...] , you can convert this script to function afterwards. DECLARE @ip VARCHAR (8000) = 'My Name is Pinal Dave'; WITH cteSplit AS ( SELECT SUBSTRING (@ip, num, CHARINDEX (' ', @ip + ' ', num) - num) AS [ [...]
SQL SERVER – Reverse String Word By Word
[...] @ip = '' END END RETURN @op END -- Usage SELECT [dbo].[fn_ReverseWordsInSentence] ('My Name is Pinal Dave') /* Dave Pinal is Name My */ Let me know if you have a better way to solve this problem. [...]
SQL SERVER – Reverse String Word By Word – Part 4
[...] @slice VARCHAR(8000) DECLARE @rtnString NVARCHAR(50) SET @Delimiter = ' ' SET @String = 'I am Pinal Dave' SET @rtnString = '' SET @count = 1 WHILE @count > 0 BEGIN SET @count = CHARINDEX(@ [...]
Related channels
-
SQL Authority with Pinal Dave
SQL Server Performance Tuning Expert
-
Uni Watch
The Obsessive Study Of Athletics Aesthetics
-
Dave Espino
Top Selling Author, Entrepenuer, Marketing Coach
-
Element14 : All Content - All Communities
All Content in element14
-
SQL Tutorials
SQL Tutorial, SQL Server, SQL Statement, SQL Query, MS SQL 2000 Reporting Service, T-SQL, SQL Function, SQL Syntax, SQL ...