mishaluba (10/27/2012)

---

Thank you very much for the great article! This certainly goes into the "briefcase". I have one question, which you sort of answered in one of the...

To Rick-153145 & aka88,

Sorry for the delay guys. I would have posted this code sooner but my 2008 R2 environment needed to be rebuilt and I just got around to...

JimS-Indy (12/4/2012)

---

Perhaps I missed something. Aren't views used in instances like this to protect the underlying (DB2) database from mistakes? A view needn't be any more overhead than a query...

Sorry for the delay. I just returned from vacation.

I am hoping you are allowed to upgrade to 2012 soon enough so you can take advantage of the newest error...

Hemant.R (12/4/2012)

---

hi,

you will get info in below way..

right click on database go to reports standard reports the backup and restore events

here u will get option successful restore...

GSquared (11/27/2012)

---

opc.three (11/26/2012)

---

You make a lot of good points which is not surprising. I do not agree with many of them but as you correctly stated that's a reserved right...

Sorry for the delay in responding. I just returned from vacation.

kwoznica (11/29/2012)

---

OPC,

When I tested it at the SQL level I was logging into the sql server as the user...

It might not be a bad idea to bypass the logic for sysadmins using IS_SRVROLEMEMBER().

E.g.

IF NOT IS_SRVROLEMEMBER ( 'sysadmin', ORIGINAL_LOGIN())

AND ... The check for num allowed in the table

Then rollback.

When...

It could be any number of things but from the information you provided so far it sounds like you may be experiencing intermittent blocking. Select count(*) with no where-clause means...

You make a lot of good points which is not surprising. I do not agree with many of them but as you correctly stated that's a reserved right of mine,...

It's quite possible that leaving the FILLFACTOR at 100 would make the most sense. With the SSD in play, the page splits and ensuing fragmentation may be less of a...

Jeff Moden (11/24/2012)

---

opc.three (11/24/2012)

---

However the OP is talking about producing their own function to generate sequential GUIDs that would not be affected by a restart. The tradeoff of course is...

Jeff Moden (11/24/2012)

---

opc.three (11/24/2012)

---

Jeff Moden (11/22/2012)

---

dave-L (11/22/2012)

---

Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.

True using a...

Jeff Moden (11/22/2012)

---

dave-L (11/22/2012)

---

Hi Jeff. That's my whole question really. Is there a good way to fix this and is it worth trying to fix.

True using a UDF to generate...

Ironicster (11/23/2012)

---

Hi guys.

Newb in SQL with what i hope is an easy one:

SELECT ACCUM.c1

FROM (SELECT t1.c1, SUM(t1.c2) as adding

FROM Table1 t1

GROUP BY t1.c1) AS ACCUM

WHERE ACCUM.adding = (SELECT MAX(adding) from...