Viewing 15 posts - 46 through 60 (of 167 total)
joepacelli (3/11/2014)
Next, comes the primary keys.
I've built my own database's at home for applications I've written for fun and with all my tables I would create a primary key which...
March 12, 2014 at 7:50 am
Hi cafescott,
It is very difficult to answer this because there is such little info about your environment, the area(s) your business operates in, the size of your estate (databases/instances/etc).
I guess...
March 6, 2014 at 3:14 am
Grant Fritchey (2/25/2014)
Like I said in my first post, it looks OK, but you need to add WITH RECOVERY to the log restore too.
It won't work if its being restored...
February 25, 2014 at 9:57 am
If you need to restore TLog backups as well, here's the scripts you can use...
------------------------------------------------------------------------------------
-- Use one of these to find out whats in the backup and what the
--...
February 25, 2014 at 9:41 am
Rod at work (2/24/2014)
USE [master]
BACKUP LOG [ASI] TO DISK = N'D:\Backups\ASI_LogBackup_2014-02-24_14-49-46.bak' WITH NOFORMAT, NOINIT, NAME = N'ASI_LogBackup_2014-02-24_14-49-46', NOSKIP, NOREWIND, NOUNLOAD, NORECOVERY , STATS = 5
RESTORE DATABASE...
February 25, 2014 at 9:15 am
GilaMonster (2/23/2014)
So why don't you post your thoughts and we can comment on them? As it is, it looks like homework and rather vague to boot.
This...
February 24, 2014 at 7:20 am
Eric Higgins (9/24/2013)
eddie.caplan (9/24/2013)
September 25, 2013 at 1:29 am
kevaburg (9/24/2013)
But in doing so, I seem to have also rattled kevaburg, and perhaps others, and being accused of 'agressiveness '.
I wasn't rattled by your response.....it was actually Peter.Rows response...
September 24, 2013 at 5:30 am
peter.row (9/24/2013)
Obviously asking for sysadmin rights just because it makes life easier you should expect to...
September 24, 2013 at 5:02 am
kevaburg (9/24/2013)
However on the other hand it sounds like you are saying that DBAs have a license to be complete arseholes and that "collaboration means licking their boots and putting...
September 24, 2013 at 3:14 am
Hi bala2,
Looking at the error, if I remember right, the account you are running under when you install the Cluster has to have the ability to register the Computer Object...
September 20, 2013 at 8:06 am
Hi,
Sorry this is a bit late, but thought I would share...
I came up against the same problem receiving the following Error Message: ‘A service specific error occurred: 1814,’ when I...
August 11, 2009 at 8:19 am
Agree with Gail, nice article, plus I'm reading it that you're suggesting that Data Storage for Temp Table is not in memory - for which it is in-memory unless pushed...
September 1, 2008 at 2:43 am
Hi,
Came across this discussion from a link to a later article...so sorry for the latness of reply, but felt I had to correct the misconception that a Baseline and Benchmark...
August 13, 2008 at 2:50 am
Viewing 15 posts - 46 through 60 (of 167 total)