Viewing 15 posts - 4,366 through 4,380 (of 6,400 total)
Only if you have dates less than 1753.
Also remember that datetime is 8 byte storage and smalldatetime is 4 byte storage, so keep an eye on page splits and fragmentation...
July 11, 2012 at 3:45 am
yet another duplicate of this topics
replies here please
http://www.sqlservercentral.com/Forums/Topic1327733-391-1.aspx
July 11, 2012 at 2:37 am
July 11, 2012 at 2:34 am
You will need to modify all sub level folders to not inherit permissions from the root directory, That way you add permissions to the folders you want them to...
July 11, 2012 at 2:30 am
TheSQLGuru (7/10/2012)
anthony.green (7/9/2012)
This will do the trick
DECLARE @d DATETIME = '1984-08-13 00:00:00.000'
SELECT CONVERT(NVARCHAR(10),@d,120)
Why are you converting to Nvarchar?? 2 bytes of storage for nothing there, isn't it?
Force of habit...
July 11, 2012 at 12:51 am
I had a couple of pints of St Austell's Tribute on Saturday, that was a good tasting ale
July 10, 2012 at 8:54 am
Old Empire is a great favourite of mine, can remember a night at uni where 10 pints where consumed in the space of around 3-4 hours. They where the...
July 10, 2012 at 8:52 am
No, thats right, 0 means midnight, 1 means 1 second past midnight
As its an INT column 000000 shortens down to 0.
July 10, 2012 at 7:29 am
Google has plenty on the topic,
but this should start you off on your search
http://msdn.microsoft.com/en-us/library/ms365937%28v=sql.105%29.aspx
July 10, 2012 at 6:56 am
All user databases use the Model DB as their template, so if Model is in FULL recovery the DB will be created in FULL recovery unless you issue an ALTER...
July 10, 2012 at 6:32 am
select @@max_connections
sp_configure 'user connections'
July 10, 2012 at 6:30 am
Possible to do in the query.
Take a look at the SUSER_SNAME(), SUSER_NAME(), USER_NAME() functions which you can pass in as the where clause and filter on the credentials column.
July 10, 2012 at 3:47 am
I take it these are the ones you are talking about?
http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/
July 10, 2012 at 1:39 am
What is the configuration?
1 instance 2 nodes
2 instances 2 nodes
etc etc
What nodes are the instances running on in Failover Cluster Manager?
What node where you running SSCM on?
July 9, 2012 at 8:09 am
GETDATE() returns a DATETIME value which rounds to .000 .003 or .007 of a second.
I would look at rowversioning using datetime2 and timestamps
http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspx
July 9, 2012 at 8:01 am
Viewing 15 posts - 4,366 through 4,380 (of 6,400 total)