Viewing 15 posts - 91 through 105 (of 588 total)
Been a while since I did this on a new 2005 server, but I believe you need to download a legacy thing from MS website to see DTS packages inside...
October 10, 2008 at 9:41 am
Security and all technical details can be overcome. What I think can not be overcome is relationships. What happens if you and the vendor holding your data has...
October 8, 2008 at 10:12 am
Not unusual at all, especially if you are backing up a database that is part of a lot of overnight batch operations. Fairly normal for me that the first...
October 7, 2008 at 9:20 am
The enrcypted items are Create Statistics done by the server, and create function and stored procedure that are done by the system....
I include the EventType from the XML, which makes...
October 2, 2008 at 3:50 pm
I think, as with most shows, if you are a professional in the field, you can find shows frustrating. Don't get me going on shows/movies that have anything to...
September 29, 2008 at 12:55 pm
True. It can, it can also happen a lot sooner than that. Point is to break it up into chunks that would not impact business. Which is...
September 29, 2008 at 11:09 am
Could break it up into smaller chunks using top(x) with a loop around it until no more records are deleted. I've used this with some success archiving data, had...
September 29, 2008 at 9:55 am
That makes no sense. If you do backups of the database that data would be all over anyhow....
If you need to remove it from disk only to the point...
September 29, 2008 at 9:47 am
If I remember right the space usage grows by 1.1 times the size of the index when reindexing. I never shrank files that grew from reidenxing as they will...
September 29, 2008 at 9:24 am
use tempdb
go
create table #ids (id int not null );
with MyCTE(id) as
(
select id from sysobjects
)
insert into #ids(id)
select id from MyCTE
August 18, 2008 at 10:05 am
Michael Valentine Jones (8/14/2008)
In the big scheme of things, the potential for abuse by a DBA is probably less than many other jobs, because the ability to turn the abuse...
August 15, 2008 at 9:43 am
GilaMonster (8/8/2008)
Someguy (8/8/2008)
skjoldtc (8/8/2008)
Woodchopping with a nice sharp axe.Axes, martial arts practitioners-
You forgot the archers.
And competiton shooters! =)
I try to go to the gym 3-4 days a week. BUt...
August 8, 2008 at 8:47 am
You have a SuperHawk and an RC51? As a previous SH owner I am jealous 🙂 It is incredible how much better of a mood I am in...
August 6, 2008 at 8:31 am
Assuming you just mean you want to see the data in a logical manner......
If you select the column with the XML data (assuming it is in an XML data type...
August 6, 2008 at 8:21 am
Viewing 15 posts - 91 through 105 (of 588 total)