Viewing 15 posts - 1,936 through 1,950 (of 5,393 total)
Looking closer at your code, you could also eliminate the JOIN with INT_PROJ_ROLE_TYP:
SELECT DISTINCT a.PROJECT_NM, a.CLIENT_NM, a.PROJECT_CD, a.Date, a.OFFICE,
ROLE = STUFF((
...
-- Gianluca Sartori
February 9, 2012 at 5:26 pm
SELECT DISTINCT a.PROJECT_NM, a.CLIENT_NM, a.PROJECT_CD, a.Date, a.OFFICE,
ROLE = STUFF((
SELECT ',' + ROLE
...
-- Gianluca Sartori
February 9, 2012 at 5:24 pm
Yes. It was named Enterprise Manager.
BTW, you can also use newer versions of the Management Studio to connect to SQL Server 2000.
-- Gianluca Sartori
February 9, 2012 at 4:09 pm
You're missing a comma after WebAddress.
In this case, ContactPerson is taken as a column alias.
-- Gianluca Sartori
February 9, 2012 at 2:47 pm
This script[/url] tracks tempdb usage per active session.
You could schedule it with SQL Server Agent and record the results to a table.
Find the culprit and fix it.
-- Gianluca Sartori
February 9, 2012 at 2:29 pm
Another vote for uninstall + fresh install.
Also, check the upgrade advisor for deprecated / incompatible features.
-- Gianluca Sartori
February 9, 2012 at 2:25 pm
My vote goes to CREATE CLUSTERED INDEX with DROP EXISTING.
It's the simplest way and it doesn't need additional steps.
Moreover, if you're on Enterprise Edition, you can do it ONLINE.
-- Gianluca Sartori
February 9, 2012 at 2:21 pm
BTW, a simple Google search could have helped:
(fourth result in my Google search)
-- Gianluca Sartori
February 9, 2012 at 9:41 am
Your I/O subsystem seems to have performance issues.
Is this a dedicated box or there are other processes running on the machine?
Is this a SAN or DAS?
-- Gianluca Sartori
February 9, 2012 at 9:39 am
xRafo (2/9/2012)
Hmm, can u prove it?, i mean,do you have an example and probe it what you say?
Table variables have no statistics. That alone should be sufficient to make...
-- Gianluca Sartori
February 9, 2012 at 9:35 am
What do you mean with "CPU usage"?
How do you get that in 2008?
-- Gianluca Sartori
February 9, 2012 at 9:27 am
Try tracing the process (sqlservr.exe) with process monitor and see what happens.
-- Gianluca Sartori
February 9, 2012 at 8:01 am
You could grab the query run by activity monitor and run it against a server group.
How to: Execute Statements Against Multiple Servers Simultaneously
Activity Monitor and Profiler[/url]
-- Gianluca Sartori
February 9, 2012 at 7:57 am
Don't rely on the fact that session_id > 51 means user process. It's undocumented and unreliable.
Try this instead:
SELECT *
FROM sys.dm_exec_sessions s
INNER JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id
LEFT JOIN sys.dm_exec_requests r
ON...
-- Gianluca Sartori
February 9, 2012 at 7:49 am
Open a command prompt on the server and type:
ECHO %USERNAME%
Is the username correct? Great, go on and connect to SQL Server using SQLCMD:
SQLCMD -Syourservername -E
Does this work?
-- Gianluca Sartori
February 9, 2012 at 1:40 am
Viewing 15 posts - 1,936 through 1,950 (of 5,393 total)