jeevan619 (9/20/2011)

---

I am working as a DBA and got a task related to SSIS package. By using SSIS package I need to develop a alert notification system.

There are...

Is the utilization drop gradual over time or more like a step ? Are you verifying the backup after finished ?

if you want only a single data flow task you can try this:-

(insert from file to Table A using Bulk Insert ) - -- ( use data flow task to...

I agree with Lowel , the correct approach would be log all queries in the database via a normal procedure call from a query webapge with text boxes. Routing queries...

TST1 (9/20/2011)

---

Hi,

I have a third party app Virutal Center which is on a consolidated server. I ran sp_who2 and it seems that it's not doing anything, but it has...

Is this is production database ? have there been any restarts?

Dotted lines are useful for the overall business but I feel often the guy at the lower end of the line does not get the required credit for the work...

Is the merge performing a huge number of inserts after that change ? The clustered index could be slowing down the insert. or if the new composite primary key is...

http://technet.microsoft.com/en-us/library/ms188388.aspx

WITH (<single_partition_rebuild_index_option>)

SORT_IN_TEMPDB, MAXDOP, and DATA_COMPRESSION are the options that can be specified when you rebuild a single partition (PARTITION = n). XML indexes cannot be specified...

if you look at the query its clear that the reason you get the value 100 is because the user_updates column is always less than 1

The user_updates counter indicates...

I agree with Steve , there is no doubt Jobs changed the face of computers and mobiles. In fact the trend has usually been Apple first and then the rest...

If your setup is something like a master page with a set of subreports embedded within it. You need to open the indivgual subreport and then export it. If you...

What kind of operations are you performing on this server? Is it a 64 Bit instance?

Have you tried DBCC DROPCLEANBUFFERS

Most of what you need you can find @BOL

you could also checkout

http://www.ssas-info.com

Analysis Server administration resources are rare compared to SQL engine administration most of it was trail and...

could you try creating a udl file (rename a text file to extn .udl) and then connecting thru it.

how about sqlcmd ?