Just as another option if you work at a shop that does not allow Ole Automation to be turned on (some consider it a security risk), you can do the...

scorpio_zz19 (3/10/2009)

---

hi,

i searched how to split the date from datetime data type and i came up with this code(below), the problem is that i dont know where to put it.

...

It looks like you have the correct path for 2005.

I am just guessing but it looks like for 2008 it is

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup\ProductID

As Manu said, covering indexes absolutely can be done in 2000. Partitioning can also be done, just not in the same fashion as it is done in 2005. ...

Could you run the query with

SET STATISTICS IO ON

That way you can see the total number of reads done for each table.

How many rows does this...

It looks like you are doing a table scan against one of those gigantic tables.

You say you have a clustered index on the Transac table but I am guessing you...

It is really interesting to see the results of the poll (at least as they are of this moment).

I think that perhaps it might be different if the poll were...

Jeff Moden (3/8/2009)

---

Heh... you are SO wrong. The only time SQL Server runs slow is when someone tries to write Oracle-like code against it. Like Gail said, they're...

That should not cause you any problems. The LSN should not get set until the end of the backup, so you should not be hurt on that front.

I have never personally seen this before, but as a possible work around you may consider running server side traces outside of profiler. You can always create a simple...

To me it looks like in terms of memory and processor you should be just fine.

I would be more concerned with the disks that you are running on and the...

Something like

osql -S ABC -E -Q "dbcc traceon(4606,-1)"

There are a few options that you could use in order to do this even with OSQL but if it were me, I would just do a backup and restore...

Barkingdog (3/5/2009)

---

Good replies but let me change the scenario a bit: suppose I am now upgrading a database from say sql 2005 to sql 2008. Other than using the upgrade...

I am thinking along the same lines as Roy here.

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

You may need to do this to get things working correctly. It seems like this is an issue where...