Try sticking something like this between setting the DB as single user and renaming it:

SELECT * INTO tempdb.dbo.temp_connected_sessions FROM sys.sysprocesses

WHERE dbid=DB_ID('DB1')

Then check the table after it's failed. Should give a...

So, you've got an ODBC data source to an AS-400 instance? If so, I think it's unlikely that anyone would have anything particularly constructive to add here as to why...

Are you connected to the DB1 database at the time, or another database on the server?

Theoretically, I guess that another user could steal the 1 connection.

Also, have you read this...

In terms of the source or destination of a data flow task, I'd definitely choose the OLE DB connection. However, if executing a stored procedure (for example) in an execute...

MysteryJimbo (1/20/2012)

---

I don't recall recommending it was grouped with in-memory dbs. I have access to around 12TB of fusion-io cards, thanks for letting me know what they are. I was...

Ok, yes, FusionIO sounds awesome, but I wouldn't group it in with in-memory databases - it's really...

MysteryJimbo (1/20/2012)

---

I'd also point out that my note worthy databases regularly hit 5 figure tps without disk issues so it is possible to have this provided your environment is configured...

Would you really want to completely destroy your database if you had a power outage, or had...

In terms of the Full Text index, the changes are applied asyncronously and I suspect that no matter how fast your disks are, there's going to be some sort of...

Although it has its downsides, if I was running 2008 SP2 or above, I'd tag an OPTION(RECOMPILE) onto the end of the statement unless it was a very high volume...

Initial testing with the sample data improves the overall time/CPU by a factor of 2, but since all the data points are randomised, this isn't that representative (as in real...

Hi Dixie,

No, there's no limit as such, although each store has a marketing radius assigned to it, which will be used in combination with the distance to say whether they...

Thanks Grant, I'll give it a try and post back.

This should do the job:

http://www.sqldbadiaries.com/2010/10/23/query-to-find-out-service-account-details/

The query is for the default instance, but is easily adapted for named instances

drew.allen (12/9/2011)

---

Maybe you can cut this down. For each new store, there are only a handful of stores where that store could possibly be closer to customers than the...