This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Poll Result - What is Your Favorite Database?

SQL SERVER – Poll Result – What is Your Favorite Database?

April 15, 2009
Pinal Dave
SQL Tips and Tricks
Database, Poll

Results of my poll What is Your Favorite Database? SQL Server won with 64% of 1,697 votes, followed by Oracle at 25% and MySQL at 8%.

Read More
SQL SERVER - Check if Current Login is Part of Server Role Member

SQL SERVER – Check if Current Login is Part of Server Role Member

April 14, 2009
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Clients sometimes forget to give me admin rights. IS_SRVROLEMEMBER(‘sysadmin’) checks if the current login is a Server Role Member: 1 means yes, 0 means no.

Read More
Visual JOIN tool.

SQL SERVER – Introduction to JOINs – Basic of JOINs

April 13, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Joins, SQL Scripts, SQL User Group

A simple introduction to JOINs: INNER JOIN and the three OUTER JOIN types, written for members of the Gandhinagar SQL Server User Group who asked for it.

Read More
SQL SERVER - FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)

April 12, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Utility

SQL Server 2005 setup on Vista said the System Configuration Checker cannot be executed due to WMI configuration. A batch file from a friend fixed it for me.

Read More
93538 Same TransactionID.

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

April 11, 2009
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table, SQL Transactions

sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.

Read More
SQL SERVER - Restore or Attach Database Without .NDF or .MDF is Not Possible

SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible

April 10, 2009
Pinal Dave
SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Error Messages

Can you restore or attach database files if the .mdf or an .ndf file is missing? In one word, no. Here is why every data file is needed.

Read More
A gardener seen from behind shines a narrow torch beam on one rose leaf with a caterpillar, the garden dark around it.

Replacing Profiler Traces With Extended Events

April 10, 2009
Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Monitoring, SQL Profiler, SQL Server, SQL Trace

Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.

Read More
Previous 1 … 36 37 38 39 40 41 42 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com