Error: Failed to connect to server BOM1-7HD1H1S.(Microsoft.SqlServer.ConnectionInfo) ***<nl/>2012-03-23 22:40:21.62 *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or...

wholegrain

this is the book i used to learn warehouseing

http://www.amazon.co.uk/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247/ref=sr_1_1?ie=UTF8&qid=1332518170&sr=8-1

COFFEE!!!!!!!!!! had to much of the stuff today, I'm wired

you need to be careful with that dont you know. putting Google into Google will break the internet due...

do you have software assurance with your SQL 2008 licences? if so and it is still valid you can upgrade at no extra cost. if you do not...

personally I like to have atleast 2 full backups on local disk but thats just me

as you say it adds complexity to the solution and if you where to restore/backup...

this is one question I used to ask when I was interviewing, I didnt know it until I attended one of Itzik Ben-Gan's training courses in London and now its...

+1 on what Lynn said as well.

As long as the secondary read-only copy is not being accessed by the web or by more than the 200 CAL's already purchased you...

hadn't heard of that tool pack until this topic, must say looks great

L' Eomot Inversé (3/23/2012)

Koen Verbeeck (3/23/2012)

Well, the local version works. If I enter...

take a look in my signature block for Jeff's string splitter

each action has a cost against it, its the SPID with the lowest cost which is the deadlock victim

if they are exactly the same in each and every way then...

the last three jobs have been a combination of time back or overtime. time back is good as you can stack up large amounts of time which give you...

open up the jobs, look where the packages are stored (msdb or filesystem) then use SSMS connected to the SSIS server where they are stored to download the packages