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...

You are not providing nearly enough info to enable us to effectively help you. Post the slow query, all table definitons (including indexes) for tables involved in the query and...

Great, you are back on track!

Theorically theres no backup full, because the recovery model was changed to simple, and full, an all lsn sequence not makes sense anymore.

Does it make...