Viewing 15 posts - 391 through 405 (of 1,518 total)
spraocs (10/26/2010)
I have another question.. Is it possible to use the ENCRYPTION BY PASSWORD temporarily and later rerplace it with the certificate?
That could be painful but not impossible.
The symmetric...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 27, 2010 at 9:03 am
No problem, I will try to post some additional info on how to work with these objects in this thread;
a lot of that will probably overlap with similar info...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 26, 2010 at 2:44 pm
I saw this link just now:
[p]http://www.sqlservercentral.com/Forums/Topic795626-150-1.aspx[/p]
One recommendation is to change the isolation level of ReportServerTempDB to READ COMMITTED.
I wonder if anyone has attempted this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 26, 2010 at 2:41 pm
spraocs (10/26/2010)
Thanks for an excellent article.. I am a developer and not a DBA. However, I cannot implement encryption without knowing the details in-depth about the same. Your article...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 26, 2010 at 12:08 pm
amit_gupta01 (10/25/2010)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 26, 2010 at 8:06 am
Here are a few:
- database mail (as opposed to SQL MAIL)
- SQL CLR (for file-system operations, web services, regular expressions)
- service broker
- "EXEC @sql AT LinkedServerName" syntax
- module signing (EXECUTE...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 22, 2010 at 11:34 am
Gianluca Sartori (10/22/2010)
Can the two DTC connect to each other?Have you checked that with DTCPing?
Got following error on local server when running DTCping:
++++++++++++Start DTC Binding Test +++++++++++++
Trying Bind to RemoteSrvr1
10-22,...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 22, 2010 at 11:03 am
Roland R. (9/15/2008)
This is the solution:http://msdn.microsoft.com/en-us/library/ms345102(SQL.90).aspx
I wonder why in that link they are using SQL CLR to implement module signing. It's not necessary.
The same solution can be implemented with straight...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 21, 2010 at 8:25 am
Suresh B. (10/21/2010)
But, in my opinion, it is better to give DBMail access to only limited number of users.
Because, it is possible to send...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 21, 2010 at 5:48 am
Frequent shrinking/expansion of the log file will also cause it to get more fragmented, another reason why you should avoid repetitive shrinking.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2010 at 5:11 pm
Run queries below to troubleshoot db-mail issues:
--get failed messages over last 5 days:
SELECT * FROM msdb.dbo.sysmail_faileditems
where datediff (day, sent_date, getdate()) < 5
--get mailitem_id from query above - eg. 2024 -...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2010 at 5:07 pm
praveen_vejandla (10/16/2010)
Suddenly if primary server is intentionally shutdown or it goes down, I...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2010 at 5:01 pm
Let's also not forget backing up the distribution database, if using replication.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2010 at 4:53 pm
reggie burns-317942 (10/15/2010)
Could I see a performance change with 2000 and 2008 if they are configured as
2000 has Windows2003 Enterprise with 8GB RAM
2008R2 has Windows2008 R2 Enterprise with 8GB RAM
Could...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 15, 2010 at 11:52 am
See also this link:
SQL-2008 Post-Upgrade Tasks - Upgrading to SQL Server 2008
-------------------------------------------------------------
1.Change the db compatibility level to 100.
2.(ONLY for database upgrades from SQL Server 2000 to SQL Server 2005/2008)
Execute DBCC...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2010 at 11:58 am
Viewing 15 posts - 391 through 405 (of 1,518 total)