Viewing 15 posts - 1,471 through 1,485 (of 1,518 total)
You wrote:
"I'm getting a DLL error when I connect to Integration Services instance from SSMS. This is another seperate issue I'm troubleshooting also."
What is the error?
"Cannot find SSPI context"?
If...
__________________________________________________________________________________
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:21 am
(1)
Is it possible for you to run the package in debug mode using Visual Studio locally on that server?
Would it run successfully?
I assume that when you were developing and testing...
__________________________________________________________________________________
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 15, 2008 at 7:55 am
I'm totally on board with the notion that in a crisis situation I need to be there for my workplace.
I also think I am a fairly ambitious and driven individual,...
__________________________________________________________________________________
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 15, 2008 at 6:42 am
ALZDBA (2/15/2008)
Just keep in mind to have your first aid kit available. 😀Also there are # of articles/forumQ regarding CLR at ssc.
I have done some ASP.NET development in the past....
__________________________________________________________________________________
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 15, 2008 at 5:33 am
ALZDBA (2/15/2008)
Very nice demo indeed ! 😎Keep in mind CLR is a double edged knife.
You can easily cut your finger with it.
Sometimes, cutting a finger is what it takes...
__________________________________________________________________________________
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 15, 2008 at 3:17 am
davidsalazar01 (2/13/2008)
The error I'm getting is that it can't create or access the "filename".csv file on the local drive. I have all the SQL Services running under the doman...
__________________________________________________________________________________
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 15, 2008 at 3:12 am
RDP as the domain acct to the machine on which the SSIS package is running.
Can you access the drive, using the same path as the one specified in the package?
__________________________________________________________________________________
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 14, 2008 at 11:52 am
In my experience, employees just starting out in the IT industry are more likely to be victimized into working an insane no. of hrs.
I started out a few years back...
__________________________________________________________________________________
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 14, 2008 at 9:51 am
Matt Miller (2/14/2008)
I'm however averse to making SQL Server the automation tool to run other things, like - file maintenance, Active directory security, etc.... There are good reasons that...
__________________________________________________________________________________
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 14, 2008 at 9:10 am
In my workplace we have recently started replacing xp_cmdshell calls with specialized calls to database objects (sprocs/UDFs) that perform file system manipulation tasks, eg. file deletion, directory listing, detection 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 13, 2008 at 11:12 pm
Thanks Todd! This is great!
I will not be able to try the download as yet, but I'm taking a note of it so I can try it when I'm back...
__________________________________________________________________________________
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 13, 2008 at 12:43 pm
kirk (2/10/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 13, 2008 at 12:18 pm
Ziljan4 (2/12/2008)
&
What...
__________________________________________________________________________________
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 13, 2008 at 11:12 am
exec sp_blocker_pss80;
"sp_blocker_pss80" gives blocking-specific output.
Look it up and download from the web. Install in master db.
Transient blocking is a normal occurrence and a consequence of database concurrency. It becomes an...
__________________________________________________________________________________
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 13, 2008 at 11:10 am
tempdb data files should be in their own drive, preferably separate spindle.
Log can be placed in the same drive as the other log files.
create as many tempdb data files 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 13, 2008 at 10:54 am
Viewing 15 posts - 1,471 through 1,485 (of 1,518 total)