Paresh Randeria (1/5/2009)

---

Is it possible to have partition across multiple databases having same schema?

If not than do we have any better alternatives?

I am working on Datawarehouse application where previous DAY...

Gail explained the basics very well at http://www.sqlservercentral.com/articles/64582/

btw you need to take log-backups to clean up the log files content !

If you don't, they will be growing on and...

Check out http://www.sqlservercentral.com/articles/Administration/2960/

it refers to http://support.microsoft.com/default.aspx/kb/954606

MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008

I've recently advised to create a number-bucket table for this kind of stuff.

Preparing a series of numbers for a key-identifier (i.e.customer in your case) and marking it 'free/taken'.

providing a sproc/function...

- did you try starting the instance using:

net start mssql$sqlexpress

- did you find the info a the folder I pointed to in an earlier reply ?

- do you have "torn page detection" set to ON for all databases ?

- do you perform dbcc checkdatabase on a regular basis ?

- try making your account member of the local windows administrators group. That may get you sysadmin rights for SQLServer.

- Take a full backup of all database(s).

- Isn't there something...

Jeff Moden (1/1/2009)

---

I'm not sure what you're talking about. A clustered index IS the data and adds almost nothing to the size of the table.

My feeling is that you've...

first read: http://www.sommarskog.se/dynamic_sql.html

Then : this is certainly not a best practice !

Create proper sprocs that serve exactly what they should.

Any "dynamic" part will come to a price.

... but I have...

No problem.

Keep us updated 😉

Happy 2009

We told you partitioning was a advanced topic.

You must read the mentioned white papers to get the actual details why and when you need to include the partitioning column !

It...

If you create all indexes without...

and you did shut it down by hitting ctrl+C in the cmdbox where you started it.

2008-12-28 20:37:46.09 spid7s SQL Server shutdown due to Ctrl-C or...

GilaMonster (12/28/2008)

---

ALZDBA (12/28/2008)

---

Does this point to a table that contains text or image columns ?

Try to export the data without these column, so you only lose the text/image stuff if...

it has troubles opening your AdventureWorks2008 database.

check your errorlog for e.g.:

2008-12-27 12:03:02.56 spid41s Starting up database 'AdventureWorks2008'.

I would try to get it back up and running...