Viewing 15 posts - 16 through 30 (of 55 total)
Since you've done several implementations, maybe you can say whether any of them have not been financially beneficial, or if they all, to some degree or another, have been, and...
*******************
What I lack in youth, I make up for in immaturity!
January 3, 2012 at 12:59 pm
>>>With 4 TB disk drives expected to dip under $200 once the Thai plants are fully back, space is usually a non-issue.
I was thinking of the stress on the SQL/SP...
*******************
What I lack in youth, I make up for in immaturity!
January 3, 2012 at 12:49 pm
Some thoughts (which may or may not be half baked, as my knowledge and experience with SP is limited)...
* Isn't storage of documents inside of Sql Server more expensive than...
*******************
What I lack in youth, I make up for in immaturity!
January 3, 2012 at 11:30 am
Maybe you could forward them to MS OneNote.
*******************
What I lack in youth, I make up for in immaturity!
December 6, 2011 at 10:45 am
I mapped my mind and I was surprised to discover that it only had two branches: "Sex" and "Donuts".
*******************
What I lack in youth, I make up for in immaturity!
December 5, 2011 at 7:52 am
Yes, unindexed views. I would love to index some of my views, but the database I'm working on was created without schemabinding. Thanks again.
*******************
What I lack in youth, I make up for in immaturity!
December 2, 2011 at 9:10 am
Okay, thanks.
*******************
What I lack in youth, I make up for in immaturity!
December 2, 2011 at 9:00 am
BIDS 2010 works.
*******************
What I lack in youth, I make up for in immaturity!
December 2, 2011 at 6:42 am
Very much for lateral thinking, rather than linear, me-thinks, and so might have stronger appeal for them (us).
*******************
What I lack in youth, I make up for in immaturity!
December 1, 2011 at 8:42 am
Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010
But I found the answer here: http://msdn.microsoft.com/en-US/library/bb677365%28v=SQL.90%29.aspx
The full add-in goes on the Sharepoint machine, files only on...
*******************
What I lack in youth, I make up for in immaturity!
November 10, 2011 at 10:10 am
Adding an integer to your code works like DateAdd() as well.
*******************
What I lack in youth, I make up for in immaturity!
June 14, 2011 at 7:26 am
It was the "Featured Script" in today's newsletter.
*******************
What I lack in youth, I make up for in immaturity!
June 14, 2011 at 6:48 am
Also, you can add or subtract days like so:
DECLARE @DateOnly DATETIME
SET @DateOnly = CAST(FLOOR(CAST(GetDate() AS FLOAT)+1) AS smallDATETIME);
print @DateOnly
Prints just like the original did, but a day later. Subtract 2...
*******************
What I lack in youth, I make up for in immaturity!
June 14, 2011 at 6:29 am
Slightly tangential, but I like to cast as SMALLDATETIME because I usually cut and paste my results into Excel; If I use a datetime, Excel shows 00:00 or somthing but...
*******************
What I lack in youth, I make up for in immaturity!
June 14, 2011 at 6:22 am
Okay, I'm sorry if I wasn't clear, but this is what I was really looking for...
Try this:
* run this script in SSMS:
SELECT
GETDATE() AS [Unconverted],
CONVERT(SMALLDATETIME, GETDATE(),101) AS [Converted]
* left click...
*******************
What I lack in youth, I make up for in immaturity!
May 5, 2011 at 2:21 pm
Viewing 15 posts - 16 through 30 (of 55 total)