allmhuran (5/10/2012)

---

...

COMMAND LINE BASE SOLUTIONS

OPTION: output to text file using bcp/sqlcmd

ISSUES: prone to special character problems, like tabs, commas, newlines etc embedded in large text coulumns such as memos,...

A couple of weeks back, I went to see "Mirror, Mirror" with my wife and kids. I went into it with only luke warm expectations, but it actually turned out...

My first guess is that it would be the result of index fragmentation or page splits.

SQL Server Fragmentation The Basics

http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/

Also, you may want to consider moving your LOB...

How to troubleshoot a Msg 823 error in SQL Server

http://support.microsoft.com/kb/2015755

To start, SQL Server 2008+ contains a system table called SUSPECT_PAGES that maintains information about suspect pages and their error...

Markus (5/16/2012)

---

Not enough really. I don't think a CIO/CEO would say that is acceptable if someone wreaked havoc on that SQL Server install or stole data from it and...

Markus (5/16/2012)

---

The big problem with running it beyond 2014 is that if a virus comes out that effects SQL2000 Microsoft will no longer create a fix for it. THAT...

No, it's not necessary. Having LoadDateTime + ID would just be an alternative...

Elliott Whitlow (5/10/2012)

---

Lynn Pettis (5/10/2012)

---

Guess I'd fail here. First things I look...

Using LoadDate as the leading column in primary clustered key makes sense in a table containing historical rows, because it's sequential (I'm assuming it's based on system date at the...

When tables and indexes are created, their internal data structure is effected by whatever collation setting was currently in effect. Similar to Fill Factor, I believe that after changing the...

Personally, I don't own an iPhone, Android device, or whatever. If I did, I'd keep my Hotmail or Gmail account stuff in the cloud and not have it setup to...

This is a good script.

One suggested addition would be a 'schemaname' column. When I'm unit testing in Development, I often times have a different version of the stored procedure...

LadyRuna (5/7/2012)

---

From examining several phones belonging to various people, I have determined that the "fingerswipe password" is essentially useless as security. It can perhaps prevent someone from accidentally opening your...

If a theif gained access to someone's smart phone, I'm sure they would be more than just a little curious about what kind of junk would be stored on it....

Does the password encrypt the critial data files on the iPhone, or is it just a means to prevent someone from accessing the folders via the operating system?

If the...