Brandie Tarvin (7/17/2013)

---

At risk of being lynched for bringing a code convo into The Thread...

Is it just me or does SQL 2008 not script out DROP CONSTRAINT correctly?

The script it...

Is there confirmation somewhere that they've actually dropped it, or is it just that they haven't bothered with the CTP?

Krishna1 (7/17/2013)

---

Thanks. But some times we notics that the server memeory utilization is more then 90%.

How can we check if its due to the SQL db or some other reason....

TUellner (7/16/2013)

---

Thanks all. I know it's not useful for anything other than a teaching tool. I was hoping to get to the execution of the dynamic SQL mess at the...

I don't believe so. The release notes say the following:

It's one to take up with your server team/HP support. ASR reboots happen when there's some hardware level panic, so it's highly likely to be hardware related (although HP will...

Indexed views have some stringent requirements on what kind of view definition they can be created on. Derived tables are not allowed.

Have a look here for a complete list of...

L' Eomot Inversé (7/2/2013)

---

You should see what one person I know wrote to a prima-donna programmer who demanded root privilege on one of the departmental Unix servers, and a...

tharwood 94756 (7/2/2013)

---

Thanks. If SQL Standard is installed on a 32-core server, how exactly does SQL Standard limit itself to 16 cores ? I am wondering...

Sorry, re-reading, I think I slightly misunderstood. You may be able to fully license the server for SQL 2012 Standard Edition (32 cores) and run both 2012 Standard Edition and...

Assuming you're talking about running on physical infrastructure on the same host, I'm fairly sure you'd need to license all of the physical cores on the box for Enterprise Edition...

Stefan Krzywicki (6/25/2013)

---

Strange as it may seem in this day and age of cheap HD space, there are still places that refuse to provide enough space for their data forcing...

If you're only applying the convert to a variable/static value, like GETDATE(), it doesn't matter at all from...

Not sure. Where was the last place you saw the table? Have you looked everywhere? Behind the sofa?

In all seriousness, it's not really possible for a backup and restore job...

Jason-299789 (6/20/2013)

---

ashwinboinala (6/20/2013)

---

i am getting this value from sysjobhistroy table from msdb there its in int format if u can give me solution where i can filter that table thats...