Viewing 15 posts - 1,411 through 1,425 (of 1,518 total)
Not only is it futile to try and defrag such small tables, but the benefit you would get, even if you were able to do so, would be negligible.
I would...
__________________________________________________________________________________
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 27, 2008 at 8:34 am
(Non-indexed) views are just a programming abstraction, made for security and convenience.
They are as good or as bad as the code in them.
__________________________________________________________________________________
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 26, 2008 at 12:16 pm
Good points guys, thanks.
__________________________________________________________________________________
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 26, 2008 at 11:41 am
I would suggest that you utilize the event-handler capability of SSIS to capture errors and record the information in a database table for later analysis. There are events you can...
__________________________________________________________________________________
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 26, 2008 at 6:47 am
Philip Horan (2/26/2008)
I am looking to walk through some of the tutorials within Visual Studio. I want to install the AdventureWorks OLTP + DW samples...
__________________________________________________________________________________
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 26, 2008 at 3:59 am
I'd add one more level of abstraction to this: create one (or more) security groups, populate them with the users and add the groups to your roles. That way, you...
__________________________________________________________________________________
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 26, 2008 at 3:53 am
As Jack mentioned earlier, do use sp_executesql in your dynamic SQL for efficient reuse of execution plans.
Even with the 100 possible columns involved here, I'm sure a handful of favorites...
__________________________________________________________________________________
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 26, 2008 at 12:31 am
Jeff (2/25/2008)
initially, the pkg will need to created & run by the developer for testing ... then i suspect we will be automating the process (importing xml data nightly) via...
__________________________________________________________________________________
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 25, 2008 at 11:26 am
Damon Wilson (2/25/2008)
What do you consider "a medium-sized SQL Server shop" to be? "DBAs" can wear an awful lot of hats. Are you the sole DBA? Are...
__________________________________________________________________________________
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 25, 2008 at 10:52 am
A programmer is just someone who writes code according to the specs.
A good programmer performs the same task as above, while, at the same time being aware of the impact...
__________________________________________________________________________________
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 24, 2008 at 12:17 am
tigersam_20002000 (2/22/2008)
What features of SQL Server require you to use full logging?
The database in question needs to be in FULL recovery mode.
Make sure you take frequent transaction-log backups when that's...
__________________________________________________________________________________
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 23, 2008 at 12:56 am
Jeff (2/22/2008)
Hello,Any suggestion on how to setup/grant access to a developer to create SSIS packages? He is db_owner in his own dev db.
Are these SSIS packages going to be run...
__________________________________________________________________________________
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 23, 2008 at 12:51 am
The other way is to launch SQL Server Client Configuration (from SQL Server Configuration Manager) and create an alias to your remote server, again using named pipes.
Again, I'm talking from...
__________________________________________________________________________________
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 22, 2008 at 8:01 am
Unfortunately, I cannot look it up from where I am right now, so I can only tell you from memory.
I think there is an Advanced (or Configure) button when you...
__________________________________________________________________________________
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 22, 2008 at 7:58 am
Muhammad Furqan (2/22/2008)
problem resolved.
what i did was that
1.i changed database owner from "administrator" to a database user like "sa"
2.set the trustworthy open to true
3.Recompiled...
__________________________________________________________________________________
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 22, 2008 at 7:38 am
Viewing 15 posts - 1,411 through 1,425 (of 1,518 total)