Viewing 15 posts - 1,081 through 1,095 (of 5,685 total)
What recovery mode is the database in, out of curiousity?
Also, what exact version and SP pack are you currently running? Any hotfixes/odd startup flags on the server?
My guess would...
October 9, 2012 at 1:59 pm
You need to call a service running on Server2 to execute the process, else the exe gets transferred to server1 and ran there. So, you'll need something already existing...
October 9, 2012 at 1:57 pm
You might want to look into the use of .RAW files in SSIS. They're basically SSIS's version of temp tables. What they do is pull off a single...
October 5, 2012 at 1:01 pm
Nadrek (10/5/2012)
CptCrusty1 (10/5/2012)
October 5, 2012 at 12:58 pm
Abu Dina (10/5/2012)
Hmmm... I made a lame attempt to answer the 8 questions. I then researched the answers online.You wouldn't have hired me! Lol 😀
Noone can know everything about SQL...
October 5, 2012 at 12:53 pm
You will need to continuously backup the transaction log, it's part of maintaining a database in anything except simple recovery. Most places I know do either 1 hour or...
October 4, 2012 at 6:31 pm
You will slightly to heavily slow down any other query using that index, but that's not a bad thing depending on how large an item you stuffed in there.
At the...
October 4, 2012 at 6:10 pm
dallas13 (10/4/2012)
That's sounds great. Thanks but I dont want CTE. Common table expression is there any other way? Thanks a ton
All a CTE presents is an encapsulated subquery. Just...
October 4, 2012 at 6:09 pm
Grab a backup and restore it on your notebook? I hate that wizard, it's got so many danged little issues.
October 4, 2012 at 4:41 pm
This is a compound problem. static is the easy part, it's consistent.
First, you need to know if you've got Y, N, or mixed. That can be handled with...
October 4, 2012 at 4:39 pm
Table tblgas01g4c40 is returning more than one distinct record for that ID. There's nothing that can be 'fixed' in the statement, you're returning too much data in your subselect.
Either...
October 4, 2012 at 4:28 pm
Chain your charindexes.
Basically, you'll want a where clause that looks like this:
WHERE
CHARINDEX( LastName, '/') > 0 -- / exists
AND CHARINDEX( LastName, '/', CHARINDEX( LastName, '/') + 1) = 0 --...
October 4, 2012 at 4:09 pm
aaron.reese (10/3/2012)
October 4, 2012 at 3:04 pm
Hey Abby,
You're new here so you're probably just not sure of how to present your issue. If you take a look at the first link in my signature below,...
October 4, 2012 at 2:48 pm
Right, use an extra column to create the identities, then a calculated column for your varchar field that converts it into the one you need with formatting
Otherwise, no, not really....
October 4, 2012 at 2:46 pm
Viewing 15 posts - 1,081 through 1,095 (of 5,685 total)