Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache. If...

can you give the query for this

you can use master.Use sp_help_revlogin stored procedure provided by Microsoft at below link to generate the script of logins with their SID on primary server & execute the same script...

Thanks

In all Database engine, administration, TSQL, BI features?

exec sp_spaceused 'tablename'

You Can these scripts to find the table spaces on the server

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count

FROM sys.dm_db_partition_stats st

WHERE index_id < 2

ORDER BY st.row_count DESC

GO

SELECT * FROM THOURS

SELECT OBJECT_NAME(OBJECT_ID) AS...

How to Backup Analysis Services Database ?

Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis

Services database and its objects.

We can take Analysis...

good question i learned new thing in 2008r2

What's New in SQL Server 2008 R2

________________________________________

The following Reporting Services features are new in SQL Server 2008 R2.

SharePoint Integration

Collaboration and Reuse

Data Sources

Data Visualization

Report Layout and...

So the two primary counters used for quickly analyzing disk performance are:

• Avg. Disk sec/Read - is the average time, in seconds, of a read of data from the...

Step 1:

Run the query in Management Studio and view the actual execution plan.

To view the execution plan, press Ctrl+M and then execute the query in SSMS.

Step 2:

Check if there are...

we can use by profiler we can do this. or else we will tune manully by step by step

All of these instructions should be done as a database admin, with the restored database selected.

First, make sure that this is the problem. This will lists the orphaned users:

EXEC...

In logshipping we can check the netwrok bandwidth raio and time taking to copy from one disk to target disk.it depends on backup issues and performance problems in the sql...