Viewing 15 posts - 4,981 through 4,995 (of 14,953 total)
Same steps as recovering any database to a point-in-time, I would guess. I don't know what "the TDE" database is, though.
Restore from the appropriate Full backup, using the With...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 10:19 am
You can definitely get that with ranking functions, or with Min/Max, more efficiently than with a cursor.
;
WITH CTE
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 9:17 am
For a job, you just pick that the step type is an SSIS package, and then tell it where the package is in the details for the job step.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 9:07 am
Here's how I do that:
SELECT DATEADD(month, DATEDIFF(MONTH, 0, GETDATE()), 0),
DATEADD(month, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0)
You can use a variable, parameter,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 9:06 am
RedGate has a product that will do that for you.
Without that, I expect it will be a matter of querying things like:
select *
from sys.sql_modules
inner join sys.servers
on definition like '%' +...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 8:38 am
The problem is a deadlock. Carriage returns won't cause that. You need to find out what the deadlock is being caused by.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 6:26 am
Dave Ballantyne (2/15/2011)
First big change i need to do today is was told to make the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 6:24 am
Enterprise Manager??
If Enterprise Manager is pinging anything from my computer, I'm really confused, since I haven't used that in almost five years! 😀
(Does this have an analog in SSMS?)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 10:01 am
Grant Fritchey (2/14/2011)
GSquared (2/14/2011)
GSquared (2/14/2011)
Tom.Thomson (2/11/2011)
Grant Fritchey (2/11/2011)
Lordy, that's still going on?
Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 9:58 am
GSquared (2/14/2011)
Tom.Thomson (2/11/2011)
Grant Fritchey (2/11/2011)
Lordy, that's still going on?
Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will this wear him...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 9:08 am
If the view references the table that is being updated, then a lock on the data in the view will block the update. That can result in a deadlock.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 8:58 am
nadabadan (2/8/2011)
GSquared (2/8/2011)
nadabadan (2/8/2011)
GSquared (2/7/2011)
nzngh (2/6/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 8:55 am
WayneS (2/13/2011)
Brandie Tarvin (2/10/2011)
It actually got down to 45 degrees F the other day. Oh, my! We had to wear coats!
I thought you Floridians broke out the coats when...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 8:29 am
Tom.Thomson (2/11/2011)
Grant Fritchey (2/11/2011)
Lordy, that's still going on?
Yes, and now as a result of nadabadan's reply to Brandie our favourite Saint is feeding the troll. Will this wear him down...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 8:21 am
Given the specification, I'd implement two parameters, one for delimiter, one for byte count. If the delimiter is null, and the byte count isn't, use the byte count, otherwise...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 14, 2011 at 7:28 am
Viewing 15 posts - 4,981 through 4,995 (of 14,953 total)