i'm looking at this as well. i've had it with full text indexing for a security log analysis solution i built up over the years. looking at analysis services and...

i do it the old fashioned way, stored procedures

some of our tables are huge and take 20 minutes per index to rebuild so we can't afford to have a job...

full backup is a full db backup

diff is all changes since last full and cumulative so you only need to restore the last full + diff

log is a log backup

been...

its part of SSMS

will logparser work?

i haven't interviewed for a while but i made up this process that worked a few times in the past.

for the week or so before the interview make a...

JamesMorrison (5/14/2012)

---

It has been my experience that most IT people have no business even conducting interviews.

Many lack the understanding of the real goal of the interview.

Often it becomes more...

doesn't seem to work through SSIS. i get an error that a temp table doesn't exist

can i use this without a dataflow task?

i'm trying to create a daily dump of...

declare @cmd1 varchar(5000)

set @cmd1 = 'select run_date = getdate(), @@servername as server_name, database_name = db_name(), a.name object_name, b.name as index_name, a.type_desc, a.create_date, a.modify_date,

b.type_desc as index_type, b.is_unique, b.is_primary_key, b.is_unique_constraint,...

tried the ms_foreachdb but for the part database_name = db_name() i only get master instead of the database the index is really in

i guess i have to go back to...

thx, i'll try it

i had some other data collection queries where i tried to use it and it didn't run the way i wanted to

our devs ended up buying cognos 10

IBM is awesome. powerplay was in prior cognos products that we have, but not in the new one we bought

forgot about this

almost a year and i'm on my second ipad 2. first one i dropped, screen cracked and apple gave me a free replacement.

i use mine mostly for reading...

will this run when a SSIS package runs as a job?

at the start of every year i try to increase the amount of logging and reporting we have to...

Grant Fritchey (1/3/2012)

---

The issue I have with the Kindle and technical books/white papers is the same thing I have with actual paper, I can't copy & paste really quickly into...