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,778 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,135 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,155 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,475 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,074 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,003 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,575 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,391 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,331 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,561 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers