Here is a quick guide I use for max server memory when I forget the settings... Not: This is not exact and may differ from machine to machine, but is...

tmccar (7/30/2012)

---

Hi Jared, Luis

"...It is creating a derived table of minimum id's when grouped by name."

Instead of creating the derived table sorted...

Luis Cazares (7/30/2012)

---

Thanks Jared, I think I couldn't have explained that well.

Of course, I know what I'm doing but I have problems to explain when I see some things that...

tmccar (7/30/2012)

---

Would you mind explaining what...

Not that I know of. This is why I keep a separate instance specifically for report server databases on the reporting server. No user databases on it.

#temp tables are available ONLY to the session that created it and are dropped when the session is closed. ##temp tables (global) are available to ALL sessions, but are...

1. If we create an index, internally this will be stored as B-Tree.

If i have created index on UserID (Integer) (Record count 100), What data...

Well... If the data has not changed, the stored procs run fine on SSMS, then something had to change in the application. It is impossible not to. Or, if...

The ultimate goal is to allow a customer to rollback any changes. Whether it is a minute ago or a day ago. We don't want to manually have...

Did you make sure the proper services are running; i.e. SQL Server and SQL Server Browser?

Also, I would go and run the stored procedure in SSMS instead of through the application. If it runs, you know it is the application. If it does...

1. What screen is giving this error? The appliction in your browser? SSMS? SSIS? VS?

2. This is clearly referring...

Jai-SQL DBA (7/26/2012)

---

Hi

I was doing regular maintainance for my DB and I found Zero Suspect Pages in MSDB DB.

Still do u think I should Run CheckDB Command .

My DB Size...

If you can provide us the DDL for the 2 tables, the stored proc, and some sample data we can look at the stored proc and many times identify the...

I thought that you must always refer to the servername\instancename when using named instances. Therefore you cannot simply reference it by alias. It will know which server to...