Viewing 15 posts - 3,001 through 3,015 (of 7,191 total)
Please will you post the execution plan?
Do you have any control over the table structure? Is it really necessary to use nvarchar (instead of varchar) everywhere?
Why are you dumping...
October 19, 2015 at 2:57 am
Is that the job history or the backup history? What do you get if you run this?
SELECT
backup_start_date
,backup_finish_date
FROM msdb.dbo.backupset
WHERE type ='D'
AND database_name = 'MyDatabase'
Is the database in Full recovery...
October 16, 2015 at 7:18 am
Does your maintenance plan just do a full database backup, or does it take a log backup, rebuild the indexes and/or run DBCC CHECKDB as well?
John
October 16, 2015 at 6:59 am
Wow - I've never been offered a job where my salary in five years' time is written into the contract!
Sean's right - it's your decision to make. But make...
October 14, 2015 at 7:50 am
The subject line is the subject line - why would you want to put information like that in it? If you really want to, you can, but your requirement...
October 14, 2015 at 7:38 am
If you're running the package interactively (in BIDS/SSDT), you'll be able to see the error messages and work it out from there. If it's running from a job or...
October 14, 2015 at 3:16 am
SSIS packages are designed to run unattended, not interactively, so don't use message boxes - they'll make your package fail as soon as you schedule it. Have you tried...
October 14, 2015 at 3:11 am
This is something that you'd normally handle in your presentation layer, front end, application - call it what you will. It's the kind of thing that Reporting Services can...
October 13, 2015 at 9:13 am
SSIS, OPENROWSET, linked server... it depends on your requirements.
John
October 13, 2015 at 4:08 am
Bring everything from the flat file into a staging table and do the checks there.
John
October 13, 2015 at 4:04 am
For proper help, please post table definitions (CREATE TABLE statements), execution plan, the CREATE TYPE statement for your dbo.TableVariable9 and the T-SQL you use to call the stored procedure. ...
October 13, 2015 at 2:26 am
Dave
Shrinking your database won't have any effect on the size of the backup, only the size of the database files.
1. Have you tried ALTER TABLE MyTable ALTER COLUMN MyColumn...
October 13, 2015 at 2:15 am
BULK INSERT doesn't take parameters in the form -U, -P and -c. I think you're getting confused with bcp.
John
October 9, 2015 at 6:18 am
SSIS is as good a tool as any. Other methods are available - linked servers, OPENQUERY and so on. You pay your money, you take your choice.
You'll use...
October 9, 2015 at 2:51 am
Knut
You need an outer join.
SELECT
r.Recipe_number
,r.Recipe_name
FROM tblRecipe AS r
LEFT JOIN tblRecipeAllergen AS a
ON r.Recipe_number = a.Recipe_number
AND a.Allergen = 'Milk'
WHERE a.Recipe_number IS NULL
John
October 7, 2015 at 4:32 am
Viewing 15 posts - 3,001 through 3,015 (of 7,191 total)