Server Configuration

perfmon counter
Is there a perfmon counter that reports task CPU usage similar to sys.dm_os_tasks, or sys.dm_exec_requests? I don't think so and in looking, I don't see any. But I thought I would check. ... 25 Feb 2010 11:26

Select previous 52 weeks for every week in calender table
Hello, I'm trying to create an SQL statement that will retrieve the previous 52 weeks for every week defined in my calender weeks table. Let's say the calender_weeks table contains 1 field called week_no - numeric (6,0). The following SQL statement works fine for a given week. I would like to know if it's p... 23 Feb 2010 13:36

Place a message in the outbox of Outlook
Is there anyone out there who can tell me how to place a simple message from within T-SQL into my Outbox of Outlook (not Outlook Express) on the same machine? I have SQL Server 7, I don't have an Exchange server and I haven't setup Mail in SQL Server. Any help will be appreciated. ... 23 Feb 2010 10:11

.net runtime optimization service event viewer Error
Hi all, After installation of SQL SERVER 2008 R2 on windows server r2 standart editon , in event viewer i saw ".NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C:\Program Files (x86)\Microsoft SQL Server \100\Tools\Binn\VSShell\Common7\Tools\VDT\DataProjects.dll . Error ... 22 Feb 2010 16:27

Space available: 0.00MB
Hi All I have SQl Server 2000.Log file was out of space(error 9002).I checked settings for log file and it was Autogrowth/10%/unristicted.Drive has 20GB free space.I added space for log file and data. Now , when i am checking Db properties it still shows :Space available: 0.00MB Any ideas Why? Thank You ... 23 Feb 2010 11:19

Replication Issue
My distribution server failed. Because of that my publishing database log file will not shrink because it is waiting to push out the transactions. I re-set up the distributer, all linked servers and logins. I still get the error below when I try to drop or do anything that matter to make replicxation work. A... 21 Feb 2010 14:54

set limit for one year prior
trying to write a query to select occupdate for one year prior to toustartdate where occupdate < (toustartdate - 365) where occupdate < (toustartdate - 1 year) don't work I'm sure it's a simple solution - can someone help me out. ... 20 Feb 2010 16:54

marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 83785
Contato: marvendas(a)gmail.com marvendas @ gmail.com marvendas no gmail.com Kit completo de solenoides para Volkswagem e Audi. O kit contem: 5 solenoides 2 Epc ( solenoides de pressao ) 1 Chicote Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M Pre�o: R$ ... 19 Feb 2010 23:19

Anyone running SQL 2005/08 under vSphere?
dtd00, Were you able to solve your problem? I'm on the same boat. jj ... 19 Feb 2010 21:07

SQL Server 2005 Networking
Is there a performance performance penalty if sql server 2005 machine has dhcp assigned address? Is there other issues with running sql server on dynamic ip server? How can I measure sql server network performance? Thanks in advance ... 21 Feb 2010 03:51