Ronen Ariely (7/16/2013)

---

Perry Whittle, i will add a comment about this maybe. thanks

But actually as the entire article is not discuss an ideal case, but a case study which should...

Nice article. Thank you for sharing.

I've always used this ref. "Negative Process ID (spid -2) in SQL Server" to guide me through this situation 🙂

jacquereed (7/15/2013)

---

I put down the answer 6,6,8,6 and it said I got it wrong, but when I ran it through my sql server, it put out exactly that -- What's...

This isn't only a great solution for the problem,

it also gets rid of the dynamic sql in the sproc, which is always a horrible thing you should...

Caps off, please. No need to shout. :ermm:

You would have to code 3 inserts

or

( since you are posting in the SQL2008 forum )

You could code a single insert and...

with regards to your Powershell script:

do you actually use an xlsx template to fill out with your data?

do you actually use any excel functionallity at all ?

if not: just change...

let me answer Q1 for you : Yes

ref: Version and Edition Upgrades http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx

Q3 We prefer upgrading using the migration path (backup/restore).

With inplace upgrades, the instance is configured starting from...

actually ... the correct answer may not be that correct at all :hehe:

It all depends on your ANSI_PADDING setting in use.

set ansi_padding off ;

declare @Vchar varchar(12)='prasad '

...

nice and simple trick.

Thank you for sharing.

have a look at http://msdn.microsoft.com/en-us/library/ms191545%28v=sql.105%29.aspx

it loads the default trace data into a temp table and queries it so it only shows Auto Grow events in a first query en in a second query it...

If you have default traces enabled ( should be the sqlserver default unless your installation dated pre RTM ), you can find information what extended your (temp)db.

/*

* Import Default...

+1

prvmine (7/2/2013)

---

Have to agree with others

- Format width should scale to the available display width - not a fan of scrolling on and on and on . . ....

not from my own experience, but this blog seems to address the same issue, but with SQL2008.

http://mssqlwiki.com/tag/failed-allocate-pages-fail_page_allocation-1/

did you try upgrading to SP4 ( sql2005) and then upgrade to SQL2008R2 ( include an upgrade to its SP2+cu6) ?