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...
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...
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...
We have partitioned fact tables (SQL 2005) in data warehouse environment and we are using ALTER TABLE ..... SWITCH PARTITION statement to truncate...
We are currently using log shipping for the reporting needs from primary database. The secondary database is log shipped every hour and exposed to...
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...
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...
I have to remove temp tables (# or ##) create permissions for the logins which do not have associated users in tempdb (using guest account). I have...
I am currently trying to write scripts / functions for data obfuscation while refreshing personal sensitive data (name,addess,SSN....) into test...
Hello SQL Gurus, I need to replay multiple production SQL traces on Test environment one by one, each taking almost 2 hours or so. I need to...
Hi Folks,<br />I need to use OPENDATASOURCE using Windows (trusted) Authentication to query another SQL server. BOL and other resources provides this...
Hi, We are observing strange behaviour in our application. The application's installation setup creates database and its objects using sql scripts....
During Log shipping, one of my TLog backup Job is continuously gives this weird error. 1) I have defined this Job to run daily at frequency of...
For one of our transactional replication server we are getting this error regularly. The process could not bulk copy into table '"tbl_City"'....
Hello everyone,<br />I have to setup Log shipping for a enviroment with Multi Servers and Multi databases. I have got very quick doubts; some of them...
Hi, I could not find detailed information/steps on how to convert the existing server(non clustered) into Node1 and add a new server to this and make...
Hello Everyone, Right now I am in Database Designing phase for a website development; where we need to store several thousands Macromedia Flash...
Hi Guys, I have to deal with Storage and Retrievel of Image and Macromedia Flash moving file (.swf file) in SQL server 2000. I am looking for...
After creating a database in SQL Server, it generates .mdf , .ndf datafiles. Generally if one can get those datafiles then he can create the...
Separate names with a comma.
