Matt Miller (4/15/2008)

---

gkruchten (4/15/2008)

---

I was asked to develop some data base recommendations for the development team to reference. One of my recommendations was:

"Consider using BIT data type columns for Boolean...

Also out of curiosity, did changing the index have an impact on performance of the query?

😎

We have a linked server setup to access a MySQL database. The view that queries the MySQL database accesses the data with the following format: FROM MySQLServer...MySQLTable.

Hope this...

Just a very simple example using just 12 rows of data. Look at the difference between how they are sorted (i.e. stored in the index).

The first data set is...

This is just a guess, but I would not be surprised that if you looked at the Execution Plan, that the query is doing an Index Scan, and if you...

A perspective employer could argue that a history of increasing salaries is a measure of competency. If you were doing the hiring and saw someone had remained at the...

As the question specificaly mentioned SQL Server 2005, you could queue up a COPY_ONLY backup to start when the scheduled backup finished. This copy_only backup would not distrupt the...

Hopefully you included the norecovery option in the restore of the full backup. if not, you will have to redo the restore of the full backup.

How many transaction log...

Just one last question, based on the sample data provided, what is your expected output?

😎

Lubo Petrov (4/7/2008)

---

properties of bak file created March 26 at 12:00:20 AM Modified at 12:01:10 AM

properties of trn file created March 26 at 12:00:22 AM Modified at 12:01:27 AM

I'm want...

have you tried this:

select

...

From what I can tell, then the only option short of sysadmin is the dbcreator fixed server role. This would allow them to create new databases, but also to...

Looks like you'd have to assign them to db_owner in those databases that you want them to have backup and restore rights. If you only want to give the...

I agree with with Matt. We just had an on-site instructor out here for a week, and we had him totally skip the Notifications part of the class just...

GSquared (4/7/2008)

---

Since you can't change the trigger, the only thing I can I can think of is breaking up the update code into batches.

if (select Col1 from dbo.Table where id...