Viewing 15 posts - 6,946 through 6,960 (of 13,876 total)
Logging information is what gets removed.
While the job is running, your other SSIS jobs will not. Do not change from 365 to 30 in one hit, it will run for...
July 11, 2016 at 5:40 pm
latkinson (7/11/2016)
we tie our database connections to specific SQL Server userid's for various security and auditing reasons.
For my own information, please give me an example of a security- or audit-related...
July 11, 2016 at 12:57 pm
latkinson (7/11/2016)
July 11, 2016 at 11:57 am
I just reread your initial post and have a question.
Would you please expand on what you mean by this:
Using Windows security to connect defeats the purpose of protecting my...
July 11, 2016 at 9:51 am
I agree that there is a fun project there. Looks to me like it should be possible, with some fancy T-SQL (a Script Component would be easier, but less flexible),...
July 11, 2016 at 9:31 am
Maybe you could try using Overwrite Mode when doing the extraction.
July 8, 2016 at 11:49 am
keymoo (7/8/2016)
Phil Parkin (7/7/2016)
Just to totally rule out a permissions issue, can you temporarily change the SQL Agent logon credentials to be yours, rerun the job & then verify (again...
July 8, 2016 at 8:30 am
GilaMonster (7/8/2016)
Phil Parkin (7/8/2016)
GilaMonster (7/8/2016)
Phil Parkin (7/8/2016)
SQL!$@w$0ME (7/8/2016)
Does the clustered key column(s) has to be NOT NULL/UNIQUE as best practice?
Yes. Otherwise SQL Server has to create its own 'uniquifier', to...
July 8, 2016 at 8:24 am
GilaMonster (7/8/2016)
Phil Parkin (7/8/2016)
SQL!$@w$0ME (7/8/2016)
Does the clustered key column(s) has to be NOT NULL/UNIQUE as best practice?
Yes. Otherwise SQL Server has to create its own 'uniquifier', to make the rows...
July 8, 2016 at 7:59 am
SQL!$@w$0ME (7/8/2016)
Does the clustered key column(s) has to be NOT NULL/UNIQUE as best practice?
Yes. Otherwise SQL Server has to create its own 'uniquifier', to make the rows unique. Read more...
July 8, 2016 at 6:23 am
vineet2507 (7/8/2016)
I think poor insert will not matter because of choice of coloumn selected but will depend upon unnecessary index and index fragmentation.
High numbers of page splits caused as a...
July 8, 2016 at 6:21 am
Grant Fritchey (7/8/2016)
Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If that's the...
July 8, 2016 at 5:41 am
keymoo (7/7/2016)
The All Executions report, overview page looks fine. Parameters Used list looks good and the UNC path name to the flat file is correct.
Just to totally rule out a...
July 7, 2016 at 4:02 pm
keymoo (7/7/2016)
July 7, 2016 at 3:30 pm
wendy elizabeth (7/7/2016)
July 7, 2016 at 3:27 pm
Viewing 15 posts - 6,946 through 6,960 (of 13,876 total)