Viewing 15 posts - 1,561 through 1,575 (of 2,008 total)
Gianluca Sartori (11/16/2011)
Does the OCI connect outside SQLServer? You can check that with TNSPING.If the connection is not successful in Oracle Client, it can't succeed in SQLServer.
It's not a common...
November 16, 2011 at 4:14 am
forsqlserver (11/16/2011)
What should be the standard best practices drive size for tempdb size in capacity planning.
Optimizing tempdb Performance
http://msdn.microsoft.com/en-us/library/ms175527.aspx
Capacity Planning for tempdb
It's a big document but you may look for very...
November 16, 2011 at 4:04 am
Here's a good place to start for looking at DBA maintenance tasks (I'm linking directly to the section on backups): http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/#_Toc209585599
Nice One 🙂
November 16, 2011 at 1:12 am
Alexander Suprun (11/15/2011)
captcooldaddy (11/15/2011)
Whenever i open a new...
November 16, 2011 at 1:08 am
The only thing is we are using replication, so I am not sure if filestreamed data can be replicated.
Yes you can but with some limitations.
Using FILESTREAM with Other SQL Server...
November 16, 2011 at 1:04 am
Our current backup plan is to send everything to the storage server
Transaction Log file every 30 min -- Checked
Full backup nightly -- Checked
System Database backup by weekly and when changes...
November 16, 2011 at 12:36 am
CDC works on individual table.
Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available...
November 16, 2011 at 12:30 am
GilaMonster (11/16/2011)
November 16, 2011 at 12:19 am
I don't think it's a limitation...
REBUILD [ WITH (<rebuild_index_option> [ ,... n]) ]
When you rebuild an XML index or a spatial index, the options ONLINE = ON and IGNORE_DUP_KEY...
November 16, 2011 at 12:07 am
mike_knipple (11/15/2011)
November 16, 2011 at 12:00 am
@tblClientIds is null
This statement is wrong. You declared it as Table variable and trying to use as Scalar variable.
In fact I am not convinced on the approach itself. Why...
November 15, 2011 at 11:48 pm
Can we replicate all the tables from one node to another in peer to peer transactional replication.
Yes
Also at any given point of time can a end user perform queries on...
November 15, 2011 at 11:38 pm
chhavinathmishra (11/15/2011)
In Windows Server 2003, you can not leverage service SIDs. Specify domain groups for SQL Server services. All resource permissions are controlled...
November 15, 2011 at 10:57 am
ricardo_chicas (11/15/2011)
Dev (11/15/2011)
I changed a couple registry
It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system...
November 15, 2011 at 10:53 am
Viewing 15 posts - 1,561 through 1,575 (of 2,008 total)