Viewing 15 posts - 46 through 60 (of 126 total)
nihal9200_kwada (5/13/2013)
We have two similar reporting servers. Lets assume them Server A and Server B
On Server B, one of the ETL package SQL agent job is failed due an out...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 3:49 pm
Many thanks for your time and thoughts
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 3:34 pm
Many thanks for your messages but I'm not sure that this is the case, this works from time to time - Surely it would be an all or nothing scenario...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 2:44 pm
From BOL -
USE AdventureWorks2008R2;
GO
DBCC UPDATEUSAGE (AdventureWorks2008R2,"HumanResources.Employee");
GO
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 8:50 am
Hi,
Thanks for the response and apologies about the vagueness. I'll try to be a bit more specific.
The SQLCmd is getting the sql from a networked file using:
sqlcmd -S...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 6:45 am
or you can use the transfer sql objects task in SSIS
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 5:43 am
Correct - 2 is not required
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 5:38 am
balasach82 (5/10/2013)
Another Q. Can a package be set with more than one config settings, so at 2 different schedules, 2...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 13, 2013 at 3:44 am
Have you re-started the server? This may be required
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 4:47 am
You would need to return all the fields in the data set but you could hide the unwanted columns and unhide them based upon a condition...or you could...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 4:39 am
Thick and eager provisioned is the best bet to avoid disk fragmentation
This may help - https://blogs.vmware.com/vsphere/2012/03/thin-provisioning-whats-the-scoop.html
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 4:20 am
You can get SSIS to download all files from the site/local folder. This may help..http://www.sql-server-performance.com/2009/data-profiler-ftp-task-ssis/2/
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 4:07 am
Not sure that I can help too much, but I would advise against using all numeric aliases. Try amending the alias to SQL2008 and SQL2005 and see if that helps....
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 3:52 am
Try the NEAR expression. That may solve the issue if you search for the word windows near 8. I assume(ok, shoot me down now) it works with numbers
BOL - CONTAINS(column_name,...
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 3:42 am
RAID 10 should be better for write operations but a more expsensive option. RAID 6 good al rounder but slower for write i/o Thick disks are probably best.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
May 10, 2013 at 3:37 am
Viewing 15 posts - 46 through 60 (of 126 total)