BACKUP LOG with TRUNCATE_ONLY is discontinued
As a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG
As of SQL Server 2008 , BACKUP...
2012-04-05
5,164 reads
SQL Server - Index Fragmentation - Understanding Fragmentation
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,382 reads
Second TPC-E Benchmark Result Published For SQL Server 2012
NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is...
2012-04-05
1,673 reads
Intel Sandy Bridge-EP Processor Recap
On March 6, 2012, Intel finally released the Xeon E5 processor family, (aka the Sandy Bridge-EP). Sandy Bridge is a...
2012-04-05
1,329 reads
24HOP Spring 2012 recordings
Many of the folks who are the PASS members, can have the possibility to watch 24 Hrs of PASS Spring...
2012-04-06 (first published: 2012-04-04)
1,966 reads
Nifty queries using a Numbers helper table
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...
2012-04-09 (first published: 2012-04-04)
4,654 reads
Using 2008 Features in a 2000 Compatibility Database
I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance...
2012-04-10 (first published: 2012-04-04)
1,876 reads
Database ownership
TweetG’day,
One of the features that I most like about management studio is the ability to generate a script of the...
2012-04-04
974 reads
I’m Speaking at SQL Saturday #118 in Madison Wisconsin
If you happen to be in the area on April 21, 2012, join us at Madison Area Technical College – Truax...
2012-04-04
603 reads
SQL Server 2012: Multidimensional vs tabular
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is...
2012-04-04
6,571 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers