check the execution plan, update all statistics rebuild all indexes

also check out the links in my signature on posting performance problems

ON ALL SERVER details that the trigger is a instance wide trigger and not specific to a database.

You could try SQL Data Generator 2.0 from Red-Gate its a licenced product but you do get a free trial, sure if you search for "SQL Sample Data Generator" you...

query sys.master_files, there is a size column which is in pages, so multiply the value by 8, to get size in KB for that file, then sum them up based...

You will need to change the event from DDL_EVENT to the correct event type which is DDL_LOGIN_EVENTS

DDL Event Tree - http://msdn.microsoft.com/en-us/library/bb510452%28v=sql.100%29.aspx

You will need to query the eventdata() to get...

Basic server wide trigger for all DDL events, need to ensure that DB mail is enabled, or change the trigger to insert into an audit table somewhere

CREATE TRIGGER ................. ON...

function sendmail{

Write-Host "Sending Email"

#SMTP server name

$smtpServer = ""

#Creating a Mail...

DECLARE @sql NVARCHAR(MAX)

SELECT @sql =

REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

--PUT WHAT YOU WANT TO DO IN EACH DATABASE IN THIS BLOCK

----

'SELECT ' + CHAR(13)...

Koen Verbeeck (1/24/2013)

---

You mean Report Manager? It's normal that it takes a while to load the site for the first time.

Either you see that as "coffee-time", or you can solve...

That is one for testing per your environment as either could produce the best result.

I would do a test without the primary key, insert the data, create the primary key...

Out of interest what is the reasoning behind having it logshipped to your developer instance?

NOLOCK - Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it...

This would be one for powershell, query the Get-WMIObject Win32_Process cmdlet see how many sqlserver.exe processes are running and if > 5 send you a mail.

Could then set it up...

What???????? NOLOCK option is not always good for reading data.

Do you understand the problems that NOLOCK give you?

Before you start putting query hints...

nivedita talukdar (1/23/2013)

---

Hi All,

I'm new to this forum and want to learn and develop SQL Server 2008 R2 Reporting services which is one of the utmost requirement to sustain my...