Viewing 15 posts - 16 through 30 (of 120 total)
Hi,
i am inserting large procedures and queires into the execl sheet.due to procedures length issue it is not fitting in the excel sheet.
February 27, 2014 at 1:25 am
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...
October 31, 2012 at 8:31 am
can you give the query for this
October 5, 2012 at 3:04 am
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...
August 30, 2012 at 12:50 am
In all Database engine, administration, TSQL, BI features?
March 21, 2012 at 4:06 am
exec sp_spaceused 'tablename'
February 29, 2012 at 2:59 am
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...
February 29, 2012 at 2:58 am
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...
December 22, 2011 at 6:26 am
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...
October 17, 2011 at 6:57 am
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...
September 15, 2011 at 8:41 am
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...
September 14, 2011 at 1:46 am
we can use by profiler we can do this. or else we will tune manully by step by step
September 14, 2011 at 1:46 am
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...
September 13, 2011 at 9:13 am
Viewing 15 posts - 16 through 30 (of 120 total)