guys, what is the best way to upgrade about a thousand SSIS packages from SQL2005 to SQL2008? Doing one by one looks tedious. Also, in what cases the...
Hello Experts, we are trying to create a non-clustered index on a 15billion row DW fact table (monthly partitioned but all data lives in two...
Does anyone has any clue on this? Any link/pointer will be helpful. Thanks
SQL server version 10.0.1600.22 (X64) I am executing several stored procedures thru SSMS and other utility., rows returned to client are 1580 but...
Thanks Frank. Actually the whole idea is to automate appropriate schema changes (as we keep changing the source table schema) to the target table...
Hi all, we have requirement where we need to dynamically create table to be used as target table in ALTER TABLE... SWITCH PARTITION statement. I am...
Would appreciate if someone could provide any hint on this?
Say if i am updating a row in a table and at the same time - other user is doing a full table scan, What happens here? Does SQL 2005 support row...
We have partitioned fact tables (SQL 2005) in data warehouse environment and we are using ALTER TABLE ..... SWITCH PARTITION statement to truncate...
It's rolling back transactions and if the log file is huge, rolling back would take considerably long. You would have to wait until log file...
YES, that option is still valid in 2005. As quick test, even with Replicate Schema Change-TRUE set on publication, I could create necessary indexes...
To quick notes on top of above: 1) Use step_name = '(job outcome)' to exclude other jobsteps and to pull total job duration only (look exact text...
What are the no of records in the table you see this behavior. I faced the similar situation earlier and what I was told by one of my friend (highly...
We are currently using log shipping for the reporting needs from primary database. The secondary database is log shipped every hour and exposed to...
Thanks much Hemant and Satya! Hemant: I am going through the article and implement in the environment. From the initial reading though, not sure if...
I wanted to check what does the values below would comprehend for Logical Disk:Avg Disk Queue Length (for data file logical drive) Min:1 Avg:2188...
The first one should perform better due to less log creation. (Bulk logged)
Thanks much everyone, I am trying to follow your suggestions and revert back if I need any clarification.
Thank you both! ddupuis, unfortunately encryption is not a option for us currently but yes may be we can implement that in our next project phase....
Hello all, I need to prevent all users (other than sysadmin/dbo) privs to access the database code (SP/Views/UDF). What would be the best way to...
Separate names with a comma.
