Viewing 15 posts - 1 through 15 (of 203 total)
9.00.3042 had a bug where a maint plan would only run against the first database listed.
fixed in 9.00.3054
consider applying Cumulative Update #3 (August 2007). KB ;939537...
October 4, 2007 at 6:40 pm
you are on Xeon processor - so i am assuming 64 bit SQL Server installation as well
- if you have not done so far, implement "Lock pages in memory" for...
October 3, 2007 at 1:48 pm
What failed? SP2 or 9.00.3050 ?
you can re-run the failed patch/or SP2.
October 3, 2007 at 1:42 pm
Put your wish to SQL Dev Team @
October 3, 2007 at 1:40 pm
can't see ur image files
August 10, 2007 at 2:29 pm
Applications such as ASP.NET use connection pool. so any website session can send any TSQL query on any of the connections that are pooled.
To ensure that the current page...
August 9, 2007 at 5:41 am
0. run update statistics with fullscan on all tables involved (by means of PK/FK)
1. run a sql profiler trace before running update. include execution plan events (showplan...
August 9, 2007 at 5:38 am
SQL Linked servers uses OLEDB.
Create a test.udl file on your box, use that to create an OLEDB connection string. And create a Linked server with that.
Check sybase's documentation for...
August 9, 2007 at 5:30 am
- get an account that can access the given share. say domain\usera.
- start SQL with that account
- write a procedure in SQL that calls
xp_cmdshell 'net use...
August 9, 2007 at 5:22 am
SQL 2005 - XML way
select col1, stuff( ( select ','+ col2
from tab1 t1
where t2.col1 = t1.col1
for xml path('')
from tab1 t2
group by col1
order by col1
July 12, 2007 at 6:30 am
SELECT TOP 100 'CREATE NONCLUSTERED INDEX IX1_' + object_name(c.object_id) + left(cast(newid() as varchar(500)),5) + char(10)
+ ' on ' + object_name(c.object_id)
+ case when c.equality_columns is not null and c.inequality_columns is...
July 12, 2007 at 6:25 am
PAGEIOLATCH_SH simply means that the SPID is waiting for some page to be brought into memory (from database files on disk).
Investigate if your IO is a bottleneck. or see...
July 12, 2007 at 6:19 am
A BLUE SCREEN (popularly called bugcheck ) is a fault occouring in Windows Kernel mode.
Any user mode process such as SQL (or a notepad or any) CAN NOT cause...
July 12, 2007 at 6:14 am
There is some misconception arounf this Scheduler error message.
Simply said, one of the SQL Server thread was executing a function call and did not yield within 120 seconds.
July 12, 2007 at 6:10 am
when procedure was taking a longer time from web site, what was the waittype / waittime of that SPID in sysprocesses ?
was it blocked by some other SPID ?...
July 12, 2007 at 5:56 am