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...
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.
February 26, 2008 at 12:16 pm
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
February 22, 2008 at 7:38 am
Viewing 15 posts - 1,411 through 1,425 (of 1,518 total)