Go to particular column and then RIGHT CLICK and then click on Expression

=IIF(user(),Fields!Sales.Value,'NA')

you can do this with IIF condition ,you can visit on this link for global parameters in...

you can check this restore statement with headeronly clause it will provide backup file information and lsn information also

RESTORE headeronly FROM DISK = N'C:\vbslog'

GO

USE MSDB

GO

SELECT * FROM...

For Date Format

http://msdn.microsoft.com/en-us/library/ms187928.aspx

For Export Utility available in SSMS (SQL SERVER STUDIO MANAGEMENT)

http://dayananthan.wordpress.com/2008/01/08/export-data-from-sql-server-to-excel-without-using-ssis-or-dts/

Export Data to Excel Videos

http://technet.microsoft.com/en-us/sqlserver/ff686858.aspx

DSN

A DSN (Data Source Name) is an identifier which defines a data source for an ODBC driver.

A DSN consists of information such as:

• Database name

• Directory

•...

Check Performance Monitor and Resource Monitor also for the specific disk issue or queue and check this query to find out the query which one is a good candidate of...

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/96648622-7b32-4106-a20b-9ef04c33362c/

http://msdn.microsoft.com/en-us/library/ms190913.aspx

open your principal database on SSMS SQL Server Management Studio and then click on new query and then pass this statement

ALTER DATABASE yourdatabase SET PARTNER TIMEOUT 30

select * from view_lan where language_id != 1

try this

http://msdn.microsoft.com/en-us/library/ms179296.aspx

http://msdn.microsoft.com/en-us/library/ms175976.aspx

http://sqlblog.com/blogs/eric_johnson/archive/2010/10/12/tsql-try-catch.aspx

There are several Administration Books for SQL Server 2008 are available on the

Books

Lab Manuals

Videos

Editor: Link removed.

you can use this command on SQL Server 2008 and 2008 R2 also,if you want to truncate the file just add new log file and restrict the first one to...

After latest full backup there is no need of previous log or previous differential backup they are useless,whenever you change the database model then you should take first full backup...

you can use SQL Server BI Development Tool with the help of SSIS package as shown in the attachements

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE...

any operation performed that was not a part of daily routine

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

is there Clustered index on this table ? if not then create it first then create non-clustered

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

Backup option perform with compression...