Viewing 15 posts - 1,936 through 1,950 (of 5,394 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((
...
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
...
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.
February 9, 2012 at 4:09 pm
You're missing a comma after WebAddress.
In this case, ContactPerson is taken as a column alias.
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.
February 9, 2012 at 2:29 pm
Another vote for uninstall + fresh install.
Also, check the upgrade advisor for deprecated / incompatible features.
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.
February 9, 2012 at 2:21 pm
BTW, a simple Google search could have helped:
(fourth result in my Google search)
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?
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...
February 9, 2012 at 9:35 am
What do you mean with "CPU usage"?
How do you get that in 2008?
February 9, 2012 at 9:27 am
Try tracing the process (sqlservr.exe) with process monitor and see what happens.
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
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...
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?
February 9, 2012 at 1:40 am
Viewing 15 posts - 1,936 through 1,950 (of 5,394 total)