Viewing 15 posts - 22,246 through 22,260 (of 26,484 total)
I think there was a little FORTRAN and GW-Basic thrown in there as well...
February 26, 2009 at 4:02 pm
If you have a command-line interfface to programs like WinZip, PKZip, GZip, 7Zip; you can use an Execute Process Task in SSIS to use one of the previously mentioned programs...
February 26, 2009 at 3:46 pm
This works in an environment using a case-insensitive collation:
FROM Master.dbo.SysColumns sc1,
Master.dbo.SysColumns sc2
But it will fail in an environment using...
February 26, 2009 at 1:51 pm
How about something like this?
with cteStaffYear as (
select
case
when a.staff = 6 then 'EM'
...
February 26, 2009 at 10:52 am
GilaMonster (2/26/2009)
Lynn Pettis (2/25/2009)
Someone want to explain what the statistics profile is saying?
Each line in the stats profile corresponds to an operator in the query. If it were...
February 26, 2009 at 10:27 am
jcrawf02 (2/25/2009)
February 25, 2009 at 9:43 pm
Before you continue, could you please answer Gails questions? You could be missing something very important because of tunnel vision.
February 25, 2009 at 3:29 pm
For the DBA to perform most of his/her work, there are times that they need SysAdmin rights. With this, all data is accessible. What this points to is...
February 25, 2009 at 3:20 pm
You know, geeks can be quite humurous. Too bad we're the only ones that seem to understand our humor! 😛
February 25, 2009 at 2:54 pm
HyperBac also has a utility for creating a native backup file from its compressed and encrypted/compressed files should you need to restore a backup file to server that does not...
February 25, 2009 at 2:52 pm
Jason Crider (2/25/2009)
What about the portability of not deal with a third party file extension?
What about your backup and restore scripts working anywhere...
February 25, 2009 at 2:00 pm
I would guess that depends on the tool.
February 25, 2009 at 1:13 pm
Tools
|_ Options
|_ Query Results
|_ Results to text
Uncheck the Include column headers in...
February 25, 2009 at 1:09 pm
Someone want to explain what the statistics profile is saying? Looks like Greek to me, and i need the English translation. This is where I would be trying...
February 25, 2009 at 1:02 pm
Not really sure. We are using HyperBac. It runs as a service and compresses our native run backups on the fly when they are done to one of...
February 25, 2009 at 12:55 pm
Viewing 15 posts - 22,246 through 22,260 (of 26,484 total)