Viewing 15 posts - 1,456 through 1,470 (of 1,518 total)
Point well taken... 🙂
__________________________________________________________________________________
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]
February 17, 2008 at 9:53 am
From "INSIDE MICROSOFT SQL SERVER 2005 - T-SQL QUERYING" by Itzik Ben-Gan, Solid Quality Learning, pg 429:
Another aspect of the IDENTITY property that can be considered a limitation in some...
__________________________________________________________________________________
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]
February 17, 2008 at 9:00 am
LDAP actually has an OLE DB -type provider, so you can actually set your Active Directory as some kind of linked server you can run queries against.
This link seems...
__________________________________________________________________________________
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]
February 17, 2008 at 8:35 am
Matt Miller (2/15/2008)
At best -perhaps look at being more selective, and rebuild the one or two indexes in a database that get changed/fragmented a lot.
Absolutely true!
Do not re-index...
__________________________________________________________________________________
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]
February 17, 2008 at 5:51 am
Living and working in Canada, an hour's drive from RIM headquarters, I am partial to the blackberry... 😉
I find it saves me time by helping me to clear out...
__________________________________________________________________________________
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]
February 17, 2008 at 5:20 am
Another issue you need to watch out for, if your requirement is a contiguous sequence of values in the identity column with no gaps in between:
The insertion of a new...
__________________________________________________________________________________
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]
February 17, 2008 at 4:29 am
Oops, let's try this again:
ALTER TABLE your_table WITH CHECK CHECK CONSTRAINT your_constraint;
USE your_db;
SELECT OBJECT_NAME(parent_object_id) AS table_name, name
FROM sys.check_constraints
WHERE is_not_trusted = 1
UNION ALL
SELECT OBJECT_NAME(parent_object_id) AS...
__________________________________________________________________________________
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]
February 17, 2008 at 2:25 am
Disco (1/14/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]
February 17, 2008 at 2:13 am
You wrote:
From research in interpreting this log, it looks like one node has an excludive on key_generator table and the other node has an update lock on the same table....
__________________________________________________________________________________
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]
February 17, 2008 at 1:25 am
AElsmore (2/15/2008)
Is there a way that I can find out which version of the .Net Framework is installed on the SQL Server without having to use a CLR Assembly?
I don't...
__________________________________________________________________________________
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]
February 16, 2008 at 5:00 am
JMSM (2/15/2008)
Hello,Can anyone tell me what permissions should i give to one user to execute Assemblies? and what is exactly one assembly?
Thanks and regards,
JMSM 😉
An assembly is a unit...
__________________________________________________________________________________
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]
February 16, 2008 at 4:25 am
David Scotland (2/16/2008)
You can check this using adsiedit but intsead of...
__________________________________________________________________________________
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]
February 16, 2008 at 4:00 am
Is the following specified at the top of your code?
[SqlFunction(Microsoft.SqlServer.Server.SqlFunction(DataAccess=DataAccessKind.Read, SystemDataAccess=SystemDataAccessKind.Read)]
__________________________________________________________________________________
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]
February 16, 2008 at 3:37 am
You wrote:
...Safe permission set doesnt solve the problem either, can you please elaborate a little more.
Based on that, I have the feeling the code fails somewhere other than the 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]
February 16, 2008 at 3:19 am
Is it possible for you to run the package in debug mode using Visual Studio locally on that server?
Yes, it runs fine when I run each component seperately.
Would 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]
February 16, 2008 at 12:28 am
Viewing 15 posts - 1,456 through 1,470 (of 1,518 total)