Hello all! Hurff-Webb has a contract position open for a mid-level SQL Server Development DBA in Jacksonville, FL. The contract starts out at 3-4 months and may last longer. The pay rate is $35 per hour W2. We offer a benefit plan including health, life, dental, and vision insurance. We also pride ourselves on our […]
2005-04-14
That's a nice try but:Trucate will Log Page deallocationTruncate Requires Elevated PriviledgesTruncate can't be executed if the table has foreign keysTruncate will LOCK the users out so if you try this in a multiuser environment you will get a lot of failed transactions ... Too many problems
2005-04-13
We setup a maintenance plan to backup 3 dbs on a server. It worked for a couple of weeks and then it started to fail. We've changed the user from domain\admin to sa and have tried other things, but nothing we do gets it to work for the schedule. We have no problems backing it […]
2005-04-08
3 reads
I thought about that and checked all my configurations options. Outside of the one I mentioned, they are identical.
2005-04-08
I think I am sorted with this now anyway.Advice is - Keep transaction very short - Return server to default isolation level READ COMMITTED when on and on error found. - Consider using HOLDLOCK
2005-04-07
that's pretty stupid that you can't use DTS; it's by far the easiest way to do this.Look in BOL under:bcp utility, format filesbcp utility, accessing and changing data:bcp {[[database_name.][owner].]{table_name | view_name} | "query"} {in | out | queryout | format} data_file [-m max_errors] [-f format_file] [-e err_file] [-F first_row] [-L last_row] [-b batch_size] [-n] [-c] […]
2005-04-06
Look up dynamic SQL on this site. Be sure to do the following: Reasons to be reluctant or/and mindful of dynamic SQL can be found here. Do read it. http://www.sommarskog.se/dynamic_sql.html 'The Curse and Blessings of Dynamic SQL'
2005-04-05
Preamble: I too studied environmental studies at UNI. and saw that all I was going to be able to do is point my finger(s) after the fact. So I found gainful employment in literally high-speed linear motor operation. So here goes the finger pointing (spelling and grammer aside): We are just a small part of […]
2005-04-05
I read an article recently called Silicon Shortage Stalls Solar. Here is a link: http://www.wired.com/news/planet/0,2782,67013,00.html. Basically it's a combination of the computer industry buying up all the silicon in bulk and the government(s) not providing incentives for solar power usage. So, the masses continue to use the cheapest option...
2005-04-05
Select StoreNo From MyTable Where DayPolled between '22-Mar-2005' and '28-Mar-2005' group by StoreNo Having Count(*) < 7Edit: Sorry I just noticed this answers only part of your question.
2005-03-31
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers