Viewing 15 posts - 1,321 through 1,335 (of 1,518 total)
Thank you Gail for clearing it up.
__________________________________________________________________________________
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]
March 25, 2008 at 9:51 am
Matt Miller (3/25/2008)
I'm anticipating not being "allowed" (by my management) to disable it even if it's possible. The marketing folks at MS have already polluted my CIO's mind....
Yikes! :w00t:
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]
March 25, 2008 at 9:45 am
I'm worried that the new LINQ technology shipping with SQL 2008 will open the door for more inline SQL code. I think it is a step in the wrong direction...
__________________________________________________________________________________
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]
March 25, 2008 at 9:13 am
SERVER1/AppDb log ships to SERVER2/AppDb every 30 minutes in standby/read-only mode. Once, ~12:15AM daily*, I run a job that does a backup/restore of SERVER2/AppDb to SERVER/ReportingDb, which would then...
__________________________________________________________________________________
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]
March 24, 2008 at 8:38 pm
gravyface (3/24/2008)
AFAIK, mirroring requires SQL Enterprise Edition, whereas Log Shipping does not. Can anyone clarify this? I think they'd rather not have...
__________________________________________________________________________________
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]
March 24, 2008 at 6:17 pm
Great link.
I would have preferred more info in it as well, but, all in all, I'm glad I got notified on it.
One question: where can I find the discovery.xml...
__________________________________________________________________________________
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]
March 24, 2008 at 2:57 pm
Jani Lane (3/18/2008)
Don't know much about security, but I've created my web service function to return a dataset from SQL Server 2000. When I invoked the function it is...
__________________________________________________________________________________
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]
March 24, 2008 at 11:43 am
rbarryyoung (3/24/2008)
Marios: Glad I could help. I lost many days to this problem the first time that I tripped over it.
Thank you!
This problem rears its ugly head 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]
March 24, 2008 at 11:41 am
Matt Miller (3/24/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]
March 24, 2008 at 11:23 am
It is indeed as you say.
When running the same SELECT linked-server query while RDP'd directly on the source server (the server instance to which the linked server is added) it...
__________________________________________________________________________________
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]
March 24, 2008 at 8:31 am
Connections are made using the login's current security context.
So in the following query, the login running the query is the same account in whose context the connection is attempted:
SELECT *...
__________________________________________________________________________________
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]
March 22, 2008 at 1:03 pm
For the reasons Michael so well explained I would caution against using the warm standby for reporting. If you do decide to do so, be prepared (and prepare your users)...
__________________________________________________________________________________
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]
March 22, 2008 at 9:31 am
I'm having the exact same issue when using a linked server on a SQL Server 2005 instance (target is a SQL 2000 instance).
The exact error is:
OLE DB provider "SQLNCLI" for...
__________________________________________________________________________________
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]
March 22, 2008 at 9:13 am
Michael Valentine Jones (3/20/2008)
You should lookat using the new row versioning or snapshot isolation levels in SQL Server 2005 to deal with these problems.
Great features but they come at a...
__________________________________________________________________________________
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]
March 21, 2008 at 7:10 pm
timothyawiseman (3/21/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]
March 21, 2008 at 6:59 pm
Viewing 15 posts - 1,321 through 1,335 (of 1,518 total)