Viewing 13 posts - 31 through 44 (of 44 total)
okbangas (3/12/2012)
Basit Farooq (3/12/2012)
okbangas (3/12/2012)
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 8:27 am
okbangas (3/12/2012)
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 8:10 am
kaplan.dani (3/12/2012)
Is it possible to have the system/resource databases stored on both node so 1 nodes backups the other one ?dani
Hi Dani,
I think this is not possible because drive...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 8:05 am
baxterr (3/12/2012)
Great article! Did you meet the SLA? Congrats on the quick thinking.
Thanks for liking the article. Yes we did meet client SLA.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 6:00 am
JManuelN (3/12/2012)
Great article: quick and effective. Just a quick question, since in SQL Server 2008 the resource database is stored in Binn directory, did the disaster affect this directory?...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comMarch 12, 2012 at 3:59 am
mike-858099 (2/21/2012)
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 21, 2012 at 8:36 am
Documented procedure worked for me as I recovered my access couple of times using this procedure.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 21, 2012 at 1:22 am
No it doesn't but you can write the code your self by using sp_who2 and DMV's ('sys.dm_os_wait_stats').
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 17, 2012 at 7:19 am
Hi,
You can implement locks in SQL Server using locking hints read below:
Hints
There are times when you need to override SQL Server's locking scheme and force a particular range of locks...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 17, 2012 at 7:12 am
dati (2/16/2012)
Please Help!How do you use Active Directory with SSRS 2008 R2, is there some setting, I've been looking but couldn't
Many Thanks.
Regards Dat.
Hi Dati,
I don't understand your question. Can you...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 16, 2012 at 2:10 pm
dati (2/16/2012)
Please Help!How do you use Active Directory with SSRS 2008 R2, is there some setting, I've been looking but couldn't
Many Thanks.
Regards Dat.
Hi Dati,
I don't understand your question. Can you...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comFebruary 16, 2012 at 2:09 pm
Here is the other flavor of the query to get quick row counts:
select OBJECT_NAME(object_id) as Table
,rows as RowCount from sys.partitions
where...
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJanuary 12, 2012 at 3:45 am
Hi, Unfortunately you are not able to do this in SQL Server.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comDecember 22, 2011 at 3:08 pm
Viewing 13 posts - 31 through 44 (of 44 total)