Viewing 15 posts - 391 through 405 (of 2,647 total)
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...
July 30, 2012 at 12:14 pm
tmccar (7/30/2012)
"...It is creating a derived table of minimum id's when grouped by name."
Instead of creating the derived table sorted...
July 30, 2012 at 10:10 am
Luis Cazares (7/30/2012)
Of course, I know what I'm doing but I have problems to explain when I see some things that...
July 30, 2012 at 9:25 am
tmccar (7/30/2012)
Luis Cazares (7/30/2012)
SELECT m.Master, t.ID FROM @tTable t
JOIN ( SELECT MIN(ID) AS Master,
name
FROM @tTable
GROUP BY name) M ON t.name = m.name AND m.Master <> t.ID;
[/code]
Would you mind explaining what...
July 30, 2012 at 9:14 am
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.
July 30, 2012 at 9:06 am
#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...
July 30, 2012 at 9:02 am
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...
July 30, 2012 at 8:29 am
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...
July 27, 2012 at 5:21 am
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...
July 26, 2012 at 2:38 pm
Did you make sure the proper services are running; i.e. SQL Server and SQL Server Browser?
July 26, 2012 at 2:09 pm
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...
July 26, 2012 at 1:43 pm
SJanki (7/26/2012)
name can not start with '>' character , hexadecimal value 0x3e.
1. What screen is giving this error? The appliction in your browser? SSMS? SSIS? VS?
2. This is clearly referring...
July 26, 2012 at 1:42 pm
Jai-SQL DBA (7/26/2012)
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...
July 26, 2012 at 1:10 pm
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...
July 26, 2012 at 12:52 pm
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...
July 26, 2012 at 12:47 pm
Viewing 15 posts - 391 through 405 (of 2,647 total)