Comments Feed

Estimate When Long Running SQL Processes Will Finish Commented on: 1 week ago (June 12, 2017)

Nice catch. I'm fixing the code now.

SQL Server Management Studio 17.1 Available for Download Commented on: 2 weeks ago (June 8, 2017)

I've not experienced it personally. Did you also see the same issue in 16.5.3?

Parsing Denormalized Strings with the STRING_SPLIT Function in SQL Server 2016 Commented on: 13 weeks ago (March 23, 2017)

Thanks! I thought I caught all those. For some reason SPLIT_SCREEN started registering in my head as I was writing the article.

SQL Server Management Studio Version 16.5.2 Now Available for Download Commented on: 21 weeks ago (January 26, 2017)

I've received the following information directly from the program group at Microsoft: "We had a customer report an issue that our perf fixes for OE table nodes has an issue with sparse columns....

Identifying Orphaned Logins Commented on: 24 weeks ago (January 5, 2017)

I'm always looking for ideas for articles. I just saw this comment and will write something up specifically to address this question for you Shankar. Stay tuned. Will get it out this month!

How Old Are Your Backups? Commented on: 24 weeks ago (January 5, 2017) Hi David and happy new year to you as well. I'm making use of template parameters in the script in the area you're referring to. To better understand template params check out these two articles: "...
What Every Accidental DBA Needs to Know Now: Backups Commented on: 40 weeks ago (September 13, 2016)

Thank you for such a kind comment. You don't know how we authors appreciate the feedback. Usually we feel we just send these articles out into the wild and never hear anything about how they are...

Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 1) Commented on: 1 year ago (February 8, 2016)

Good point. I'll edit the script to note that and also provide an alternate for older versions back to 2005. Thanks.

Identifying Query Text and Graphical Execution Plans in Active Queries Commented on: 1 year ago (December 10, 2015)

Anggara, this works fine when I copy and paste it into SSMS. There is nothing to fix syntactically. Can you tell me what version of SQL you're running and the collation setting if not default?

Identifying High-Impact Queries and Stored Procedures with Dynamic Management Views Commented on: 1 year ago (October 2, 2015)

I suspect you may not have swapped-out the template parameter in the WHERE clause.

If you want to return results for the entire instance then comment out the WHERE clause otherwise use the...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More

Sponsored Introduction Continue on to (or wait seconds) ×