Viewing 15 posts - 1,381 through 1,395 (of 3,221 total)
Without knowing more about what you will be using this route data for, I can only suggest your NOT using NULLs. As you are well aware a NULL...
March 14, 2011 at 7:08 pm
Is this what you are looking for?
DECLARE @BeginDate DATE
DECLARE @W DATE
SET @BeginDate = '28 feb 2011'
--Included so as to see what is happening -remove in actual use
SET @W = ...
March 14, 2011 at 12:24 pm
The bottom level of nodes in the index is called the leaf nodes
In a clustered index, the leaf nodes contain the data pages of the underlying table.
Read this article...
March 12, 2011 at 3:03 pm
Caroline Hecht (3/11/2011)
March 11, 2011 at 1:47 pm
stewartc-708166 (3/11/2011)
The options listed are classified as Large-Value data types, not LOB'srefer:
SQL2005: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.90).aspx
SQL2008: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.100).aspx
SQL2008R2: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.105).aspx
And yet this:
http://msdn.microsoft.com/en-us/library/ms187752.aspx
In SQL Server, based on their storage characteristics, some data types are designated as...
March 11, 2011 at 7:35 am
Try this:
SELECT
REPLACE(CONVERT(varchar,cast('2011-03-09 15:16:41'as datetime),101),'/','-')
March 10, 2011 at 4:38 pm
This might be what you want (sysdbmaintplan_history )
http://technet.microsoft.com/en-us/library/ms173549(SQL.90).aspx
March 10, 2011 at 3:58 pm
For reasons of performance the recommendation is that 1000 files per folder is not exceeded. But no reference has been included in the explanation. So the justification for...
March 10, 2011 at 10:07 am
Here is an article, complete with sample code that may provide the T-SQL code you are searching for:
http://www.mssqltips.com/tip.asp?tip=1202
Additional data replete with many, many code samples
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
Another possible method, have Excel pull...
March 9, 2011 at 8:42 pm
GilaMonster (3/9/2011)
March 9, 2011 at 11:03 am
Hope this helps. From a blog posting by Steve Jones (Yes Steve Jones of SSC)
TriggerProper trigger writing/* Steve Jones Blog Posting
Create trigger orders_update_inventory on orders
for...
March 8, 2011 at 5:03 pm
Without knowing what indexes exist it is hard to optimize the T-SQL as I am sure you understand. Now just to give you an additional approach you might want...
March 8, 2011 at 2:49 pm
Please, please read this posting by Steve Jones (posted today as an editorial)
http://www.sqlservercentral.com/articles/Editorial/72676/
Added at 11:35
Also be sure to read the forum discussion on Steve's editorial.
-----------------------
If that does not get you...
March 8, 2011 at 9:25 am
Duncan Pryde (3/8/2011)
bitbucket-25253 (3/7/2011)
Duncan Pryde (3/7/2011)
I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)
It's...
March 8, 2011 at 6:19 am
the table contains data for workflow auditing...tracking steps through a workflow.
after modifying thier query, the execution plan does change. However, it still has a sort step with 30%. I'm thinking...
March 7, 2011 at 8:47 pm
Viewing 15 posts - 1,381 through 1,395 (of 3,221 total)