Using SQL Server 2012 FileTables
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,771 reads
Basit's SQL Server Tips
SQL Server 2012 Installation Guide
This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...
2012-06-23
215,125 reads
Determine Index Fragmentation in a SQL Server Database
Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...
2012-06-18
9,151 reads
Storage options available in Windows for SQL Server
There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...
2012-06-16
2,474 reads
Find unused indexes using sys.dm_db_index_usage_stats
The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...
2012-06-15
10,062 reads
SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]
Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...
2012-06-06
25,001 reads
Unable to recycle SQL Agent log: SQLServerAgent Error: 32.
Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...
2012-06-06
2,571 reads
Tips to avoid deadlocks?
A database server should be able to service requests from a large number of concurrent users. When a database server...
2012-06-04
3,385 reads
SQL Server 2008 Security Best Practices
If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...
2012-06-01
13,323 reads
New built-in functions in SQL Server 2012
Introduction:
Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for...
2012-05-26
25,533 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers