Viewing 15 posts - 676 through 690 (of 928 total)
Are you sure that your log-shipping is actually working? The message implies that it has been a little over two years since the databases were last in sync.
There is an...
October 20, 2011 at 8:40 am
Jayanth_Kurup (10/13/2011)
October 13, 2011 at 6:53 am
If some form of source control is in place then that must be the only source used for code. When someone sends a version of code via email, no matter...
October 13, 2011 at 3:51 am
I know a few users I'd like to send into space.
October 13, 2011 at 3:06 am
Within SSMS right-click on the database name and select Tasks/Generate Scripts.
Is this what you need?
October 6, 2011 at 2:32 am
Have a close look at your '%Growth' - the ',2' is in the wrong place.
October 6, 2011 at 1:31 am
96% of answers incorrect - you'll be popular! No cheap points here.
October 5, 2011 at 1:12 am
We have a similair setup here, where a software package upgrades a database to the latest version but occassionaly alterations have to be made before and after this for a...
October 4, 2011 at 1:59 am
Have a look at String Functions in MSDN http://msdn.microsoft.com/en-us/library/aa258891(v=sql.80).aspx.
I would probably use PATINDEX to locate the first '/', you know the date starts 2 characters before this and then locate...
September 27, 2011 at 7:53 am
Thanks for the reply. Now that I know that, I've worked out what to search for: http://msdn.microsoft.com/en-us/library/cc835497.aspx and http://stackoverflow.com/questions/1128597/is-there-a-64-bit-version-of-ssms-and-bids-with-sql-server-2008-64-bit.
Thanks for your time.
September 15, 2011 at 1:56 am
Dave Ballantyne (9/14/2011)
BTW Anyone going to SQLBits or SQLRally Nordic this year ??
And if you are in the UK ( or will be in the UK) dont forget to...
September 14, 2011 at 6:20 am
I normally don't comment on QOD articles, but the explanation and screen-shot of the execution plan deserves merit.
September 1, 2011 at 1:14 am
Grant Fritchey (8/12/2011)
August 16, 2011 at 3:29 am
http://www.sqlservercentral.com/scripts/DateTime/61691/
This returns just the date, although time is still present as 00:00:00. See the discussion for that article for further examples.
BrainDonor.
August 3, 2011 at 1:20 am
Viewing 15 posts - 676 through 690 (of 928 total)