Comments Feed

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

Nice catch. I'm fixing the code now.

SQL Server Management Studio 17.1 Available for Download Commented on: 10 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: 21 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: 29 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: 32 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: 32 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: 48 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
Jul 17, 2017
Sponsored

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
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

Sponsored Introduction Continue on to (or wait seconds) ×