Viewing 15 posts - 1,486 through 1,500 (of 1,584 total)
Well, you can create a series of alerts (Under SQL Server Agent >> Alerts) - SQL2005 has a pretty wide range of alerts for DB file growth/% used and such...
Example...
May 25, 2011 at 10:53 am
Is the query you killed running on a remote/linked server? If so, it's possible it's in a KILLED/ROLLBACK state on the server you killed it from, but still running...
May 24, 2011 at 10:46 am
I don't suppose someone could actually post what was changed in the config files for these past 2 posts? 🙂
May 18, 2011 at 12:11 pm
In that case try this:
(DISCLAIMER :: there's probably much better ways to accomplish this but I prefer this because it's easier to write and modify)
Alos, you'll need to have xp_cmdshell...
May 12, 2011 at 9:58 am
Do you ultimately want to load one XML file at a time from the directory or loop through and load them all at the same time?
If it's just the one...
May 10, 2011 at 8:58 am
Hey I'm here to learn as well and am by no means an expert 🙂 Just trying to reiterate something that I was taught (apparently mis-taught) without ever validating...
May 9, 2011 at 12:47 pm
Shouldn't SELECT COUNT(1) be the preffered method here over (*)? In larger tables I've noticed drastic performance improvements by choosing only 1 column...
Also, linked servers can be sporadically "quirky"...Do...
May 9, 2011 at 11:01 am
I use this all the time with great success:
Script #1 (saved as setup.bat)
set ServerName=YourServer
set DBName=YourDB
set sql_login=YouUser
set sql_passwd=YourPwd
Script #2 (saved as DeployScripts.bat)
@Echo Off
goto skipcomments
rem
:skipcomments
call setup.bat
if not "%UserName%"=="" goto ok
goto...
May 6, 2011 at 1:50 pm
While you don't specify where the data you're importing is coming from (flatfile, another table, etc). You should use a WHILE loop to batch process your records. You can...
May 2, 2011 at 2:13 pm
I disabled the DELETE file control and replaced it with a simple script and it appears to have worked. Go figure :S
I really don't get this SSIS...what on earth...
April 27, 2011 at 1:21 pm
Well I thought this was fixed.
Randomly it appears to rear its ugly head.
Again, everything in the package runs successfully (all GREEN) yet there are errors with the foreach...
April 27, 2011 at 8:48 am
How would I go about adding that (forgive me but I'm not that accustomed to SSIS yet)
April 25, 2011 at 1:43 pm
This has been resolved. In case anyone's interested the issues lays with setting the variable beforehand.
Variable Mapped:
Name: RRINVHDR
Scope: Package Level
Data Type: String
Value: F:\ETLDrop\work\RRINVHDR.dat
The value should be set to an...
April 22, 2011 at 2:40 pm
NEVER use BETWEEN on dates with times.
Why?
April 14, 2011 at 9:20 am
The main table (with potentially millions of records) exists and has data the the BI team reports against. The flatfiles contain data that may or may not already exist...
April 14, 2011 at 9:05 am
Viewing 15 posts - 1,486 through 1,500 (of 1,584 total)