Viewing 15 posts - 241 through 255 (of 256 total)
Until it happens to you, one doesn't really understand these oft-repeated mantras:
• have a career rather than job
• always be learning and get official recognition for your knowledge...
July 15, 2011 at 3:35 am
DBAs are often «cost-centres» and self-directed time is often neither understood nor appreciated by those above. It can be hard when one has to account for one's time in 15-minute...
May 13, 2011 at 3:17 am
Hi Oliii
We are running two instances joined by replication at the moment. I have been told that I will be getting 3 blades for the cluster. One node must be...
April 28, 2011 at 6:14 am
I reckon that you'd have to read the terms & conditions for standard edition completely and I suspect that it won't be allowed.
However, have you considered several 2-node active/passive clusters...
April 28, 2011 at 3:13 am
@Syed Jahanzaib Bin hassan: I understand the logic of services being started on the chosen node on failover. I'm not clear about the definition of the shared disks. They must...
April 28, 2011 at 12:44 am
The title of the article is, 'Column Order in an Index'. I expected proof that there was a performance difference between the order of columns in a composite index or...
November 24, 2010 at 7:59 am
I have to admit that I am not impressed with the title. It is wrong. According to your article, the column order in a composite index is not important.
From the...
November 24, 2010 at 1:39 am
PaulB » Databases are handled by SQL Server instances.
PaulB » SQL Server instances are handled by Operating System
Hi PaulB,
This I know. I am new to multiple instances on one server...
August 6, 2010 at 12:07 am
Hi,
I thoroughly recommend the SQL Cookbook from O'Reilly. It's not too bad for beginners of SQL and it gives each 'recipe' in 5 flavours of SQL (Oracle, DB2, Transact...
March 18, 2010 at 6:10 am
Hi,
The first thing that comes to mind is that you are asking someone to do your work for you.
The second thing that comes to mind is that...
March 18, 2010 at 5:43 am
I could, I suppose. The problem is that, aside from malevolent external intervention, the only people who have such write-access are the DBAs and the Sysadmins and none admit to...
January 10, 2010 at 11:24 pm
Thanks very much for the script! It is extremely useful and it's good to learn about new DB objects. I see now that I'm much more ignorant about traces than...
January 8, 2010 at 7:59 am
You can do it simply by dropping/deactivating all logins and all of their associated users. Why you would want to do it, however, I'm not sure.
January 6, 2010 at 6:15 am
Wouldn't shrinking the DB also reclaim the space lost by the dropped column?
July 28, 2009 at 11:35 pm
Viewing 15 posts - 241 through 255 (of 256 total)