Viewing 13 posts - 1 through 13 (of 13 total)
Excellent illustration of how query folding and constant evaluation is used by the query optimizer. Many thanks Carlo.
April 23, 2015 at 2:38 am
I am still none the wiser as to what the "SQL Server backlog queue" is.
However in case anyone else encounters the "Communication failed" when an SSIS Execute SQL task is...
March 1, 2011 at 3:25 am
GilaMonster (8/31/2008)
Just one small thing. You say that for data storage, temp tables are in TempDB and table variables are in memory and tempDB. I may be misunderstanding what...
January 24, 2011 at 8:29 am
Hi there Steve, I am unable to locate the advanced counters article mentioned in the first bullet point to the first paragraph. Do you have a link to it?
Many thanks,...
January 16, 2009 at 4:03 am
This is by far the clearest explanation of Kerberos and its relevance to SQL Server that I have seen. Many thanks!
December 11, 2008 at 3:47 am
I'm having the same issue on a 32 bit machine. Has anyone got this working ever in SQL 2005?
October 22, 2008 at 10:01 am
I would look to do this work in half a day, but then my section is geared up to carry out this work regularly on a standardised and scripted basis.
If...
September 23, 2008 at 3:47 am
Vika (9/4/2008)
September 5, 2008 at 4:43 am
Thank you, that was just what I was looking for, and an alternative to the perils of xp_cmdshell.
I've not come across xp_servicecontrol before, and after a quick google discovered that...
May 22, 2008 at 7:11 am
I am trying to detect whether the SQL Agent service is running, from within T-SQL.
May 21, 2008 at 7:31 am
AndrewSQLDBA (12/23/2007)
You should never use ODBC to connect to SQLAndrew SQLDBA
Why is that? You havn't given a valid reason for saying this.
April 28, 2008 at 4:32 am
Print version is broken:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data...
April 23, 2007 at 4:21 am
Thanks!
I was looking in sys.sysdatabases!
August 30, 2006 at 7:06 am
Viewing 13 posts - 1 through 13 (of 13 total)