Fix for index corruption issue || SQL Server 2012 Service Pack 2
ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...
2014-06-24
895 reads
SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,247 reads
SQL Server Database Ownership: survey results & recommendations
SQL Server Datenbankbesitz: Umfrageergebnisse und Empfehlungen
(en)
You may remember the survey on database ownership which I launched several months ago.
In...
2014-06-27 (first published: 2014-06-23)
2,926 reads
SSC Editorial: Bad Meetings or Meeting Badly
Bad Meetings or Meeting Badly is the editorial of the day today. Looking at it today, I wish I had...
2014-06-23
518 reads
Last Weeks Top “Reading” Links #89
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-23
492 reads
Reading, Writing, and Riskmetic-Question of the Day
Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...
2014-06-23
542 reads
SQL Server 2012 || Contained Database
Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...
2014-06-23
9,302 reads
sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
697 reads
Using PowerShell to Build your Azure VM Environment
In a previous post I wrote about Using a Hyper-V VHD in an Azure VM. Today I’d like to show...
2014-06-23
1,654 reads
Introduction to Latches in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-23
2,879 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
BCA KCU WISMA MILLENIA Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec....
Alamat Kantor BCA KCP Blok M Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta...
BCA KCU KUNINGAN Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
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