Viewing 15 posts - 946 through 960 (of 1,518 total)
Thanks guys, I will try not to disappoint... 🙂
__________________________________________________________________________________
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]
September 3, 2008 at 8:20 am
Grant Fritchey (9/3/2008)
__________________________________________________________________________________
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]
September 3, 2008 at 6:23 am
ALZDBA (9/2/2008)
However, if you're going for partitioned objects, you should keep in mind there is a huge advantage in...
__________________________________________________________________________________
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]
September 2, 2008 at 1:36 pm
Lynn Pettis (9/2/2008)
__________________________________________________________________________________
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]
September 2, 2008 at 1:27 pm
Thanks for the input!
__________________________________________________________________________________
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]
September 2, 2008 at 12:02 pm
In the TextData column add a filter that reads like this:
Like '%yourSprocName%'
I recall trying this once and not being able to get it to work. Test it out first.
__________________________________________________________________________________
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]
September 2, 2008 at 11:59 am
joseph.dasnevis (9/1/2008)
That's the problem, I have to process incoming emails to capture data into a db table and I believe db mail doesnt have this feature.
I now see the issue,...
__________________________________________________________________________________
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]
September 1, 2008 at 6:04 pm
joseph.dasnevis (9/1/2008)
Thanks, but can you pls let me know how I can read and process incoming emails through DB mail.
Ours is a pretty simple requirement - just be able to...
__________________________________________________________________________________
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]
September 1, 2008 at 5:56 pm
If you are dealing with a small db with low activity and/or are using it in a dev/test environment, it is *OK* to put both on same drive. The previous...
__________________________________________________________________________________
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]
September 1, 2008 at 5:37 am
Restore your master db backup as another name, say master_bk, and check the sys.server_principals view. It will give you all server logins. It won't give you their mappings onto...
__________________________________________________________________________________
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]
September 1, 2008 at 5:31 am
Are you local admin on the machine?
__________________________________________________________________________________
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]
September 1, 2008 at 5:18 am
sudhakara (8/31/2008)
"A significant part of sql server process memory has been paged out. This may result in a performance degradation.
...
__________________________________________________________________________________
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]
September 1, 2008 at 5:13 am
joseph.dasnevis (8/31/2008)
Thanks. Yes I'm aware of that but I've configured SQL Mail to process incoming emails and Database Mail to send out emails.
Was there any reason for this? DB mail...
__________________________________________________________________________________
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]
September 1, 2008 at 5:00 am
The sample project is ready. How can I send you the zip file?
__________________________________________________________________________________
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]
August 29, 2008 at 11:08 am
I think it's easier if I create a sample report project and send it to you.
Pls stay posted.
Anyone know how to add attachments to a thread?
__________________________________________________________________________________
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]
August 29, 2008 at 9:21 am
Viewing 15 posts - 946 through 960 (of 1,518 total)