Viewing 15 posts - 1,246 through 1,260 (of 1,518 total)
Thanks for your thoughts folks. I will keep them in mind moving forward.
I will update this thread with new developments.
__________________________________________________________________________________
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]
April 17, 2008 at 8:01 am
In our case, the web service is being invoked from a SQL job off hours when activity on the server is at a minimum.
I share concerns you guys have 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]
April 17, 2008 at 7:48 am
I was about to tell a developer to add owner/schema for all objects referenced in a sproc, but after this test, it seems that does not matter...
I do agree though...
__________________________________________________________________________________
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]
April 16, 2008 at 8:11 pm
I think I've got it. I dissected the code in sysprotects and voila:
USE dbName;
IF EXISTS (SELECT * FROM sysprotects WHERE user_name(sysp.uid) = 'dbRole')
EXEC sp_helprotect NULL, 'dbRole';
__________________________________________________________________________________
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]
April 15, 2008 at 1:42 pm
I'm getting the following error when I run:
USE dbName;
EXEC sp_helprotect NULL, 'dbRole';
Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
There are no matching rows on which to report.
I take...
__________________________________________________________________________________
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]
April 15, 2008 at 12:30 pm
SQLServerLifer (3/18/2008)
One other item to consider in SQL 2005 stored procs is ths use of fully qualified names. So will improve cache hit/miss events.DAB
I used to think so...
__________________________________________________________________________________
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]
April 15, 2008 at 8:59 am
Also, keep in mind that re-indexing updates index statistics as well, whereas index re-organization does not update index stats.
Run the following statement at least once a week on every 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]
April 14, 2008 at 3:38 pm
andrew6123 (4/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]
April 14, 2008 at 3:28 pm
K. Brian Kelley (4/12/2008)
Are there other MSSQL.N folders? The folders are numbered based on when the services were installed.
The root directory for my instance is: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL.
I 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]
April 14, 2008 at 10:48 am
Check out Brian's response, posted on 3/26/2008 11:46 AM, at
http://www.sqlservercentral.com/Forums/Topic471172-359-1.aspx
__________________________________________________________________________________
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]
April 14, 2008 at 10:13 am
Thanks guys!
I have been able to locate the following path in the registry, but there is no "port" entry under there:
Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\
I wonder if I'm looking in the right...
__________________________________________________________________________________
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]
April 12, 2008 at 9:44 am
thank you, but I get this error when running this:
RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'
Msg 22001, Level 1, State 1
Port Number:
__________________________________________________________________________________
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]
April 11, 2008 at 11:31 am
If you are using Windows auth., switch to SQL authentication instead. This is the (in)famous double-hop authentication problem, whose resolution still evades me. If you RDP to the originating server...
__________________________________________________________________________________
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]
April 11, 2008 at 10:34 am
I would think sending a smaller batch to the server at one time (say a one-line DML statement) vs. a larger batch (1,000s of lines) would have an effect on...
__________________________________________________________________________________
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]
April 11, 2008 at 7:17 am
Thanks folks for your replies and feedback.
Can someone confirm whether or not adding GO statements between individual DML statements in a script helps in reducing utilization of network resources?
__________________________________________________________________________________
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]
April 11, 2008 at 7:03 am
Viewing 15 posts - 1,246 through 1,260 (of 1,518 total)