SELECT GetDate() – 30 AS [This actually works??];

I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....

SharePoint Reports and Scorecards on Apple Devices

While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to...

Why Do I Blog? #meme15

As I mentioned in a post last week, a new meme has been born.  This one is dedicated to discussing...

Undocumented Gotcha in Merge Replication Tracking

In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an...

Using Dynamic Values in XMLA

Using Dynamic Values in XMLA
XMLA

A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...

Albanian SQL Server Users Group - First meeting

Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...

Albanian SQL Server Users Group–First Meeting

Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users...

Configuring and monitoring transactional replication between two SQL Server 2005 instances…

Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing,...

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so...