I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components such as using Row Count component, for this you have to create a variable of integer ...

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for any of the databases on that SQL Server instance, on the down side it is not recommended in ...

No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000 to 2005. In this case you can take few advantages of SQL 2005 by keeping the user databases in ...

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id, r.status, r.wait_time,wait_type,r.wait_resource, substring(qt.text,(r.statement_start_offset/2) +1, ...

Millions hit by Monster site hack So even job site is no exclusion for Hackers, you might have come across spams & phishing sites but accessing the confidential information from a website is nothing you can do rather change your details in order to secure your data. Monster.com site had this problem of hacking the confidential details of more ...

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I ...

High-speed heterogeneous integration is a challenge for many corporate IT departments today. Most modern IT groups are having to deal with an incredible amount of disparate systems across the organization, coupled with an ever-growing data set. To address these challenges, many IT pros are looking at bringing in high-speed data interconnects to ...

SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + ' ' + case when syscolumns.isnullable = 1 then 'NULL' else 'NOT NULL' end sql from syscolumns inner join sysobjects on sysobjects.id = syscolumns.id inner ...

Cross post from Mladen Prajdic blog- http://weblogs.sqlteam.com/mladenp/archive/2007/07/06/60250.aspx...(read more)