Viewing 15 posts - 15,166 through 15,180 (of 39,970 total)
The only decent week I've had. Big Ben and Shawn Greene are killing me.
October 3, 2011 at 7:44 am
You can close some connections and those objects will drop their tempdb space. Or cancel the transactions.
You could try adding 5MB to the existing file and then grow on...
September 28, 2011 at 9:58 am
Clustering works with shared storage. When the passive node picks up, it picks up the storage that was being used by the active node. Some SAN technologies or geo-clusters play...
September 28, 2011 at 9:52 am
Yes, here's some powershell code that does that and runs a backup of there's an alert. however the comments describe essentially what you're doing: http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/
September 28, 2011 at 9:50 am
Brandie Tarvin (9/28/2011)
Do not tempt me. I have done things like this before. @=)
Speaking of writing, follow this link if you like high fantasy and want to read a story...
September 28, 2011 at 9:26 am
Once the iSCSI disks are attached, the procedures for both of these are available in books online or on the web. I would suggest searching for them.
September 28, 2011 at 7:20 am
You'll need to grow tempdb to gain a little space for the growth operation.
You can restart SQL Server as well to clear the tempdb db and recreate it.
September 28, 2011 at 7:19 am
Easiest way is to backup and restore as a new database (new name), delete the data in each database you don't need.
If you do this regularly, you need to build...
September 28, 2011 at 7:16 am
Brandie Tarvin (9/28/2011)
SQL Kiwi (9/28/2011)
WayneS (9/27/2011)
• ...
September 28, 2011 at 7:08 am
Do you mean "can I" technically, in that will it work? Or "can I" license-wise?
The former is yes: http://msdn.microsoft.com/en-us/library/ms143393%28v=SQL.100%29.aspx
The latter is no, not without a cost. Even with software assurance,...
September 27, 2011 at 8:53 pm
It would depend on the deletes. The extents could be reused, and dropped out on deletes, but if you deleted a page or two out of each extent, I'm not...
September 27, 2011 at 8:48 pm
Might look at Glenn Berry's diag queries as well: http://www.sqlservercentral.com/blogs/glennberry/archive/2011/09/27/september-2011-sql-server-2008-instance-level-diagnostic-queries.aspx
September 27, 2011 at 8:45 pm
With Profiler/trace you'll see all the activity, but that doesn't show you what changed. Without a trace from before, it's hard to know.
What I'd do is grab the statement...
September 27, 2011 at 8:45 pm
I do see some MVPs posting about their work with Azure and asking questions about how things function and when changes are coming. Not sure what I can disclose about...
September 27, 2011 at 8:35 pm
WayneS (9/27/2011)
September 27, 2011 at 8:28 pm
Viewing 15 posts - 15,166 through 15,180 (of 39,970 total)