Viewing 15 posts - 1,771 through 1,785 (of 3,232 total)
Search this site for 'split' and you'll find a number of split functions.
May 19, 2008 at 4:41 pm
pvnlaks.mscis,
What makes your problem similar? Are you having problems with the FTP part or the XML part? I would suggest starting yourself a new thread with a...
May 19, 2008 at 4:39 pm
The first question I'd ask is, can you import the data directly into Oracle using Oracle utilities? When I worked with Oracle, there was a utility called SQL*Loader that...
May 19, 2008 at 4:37 pm
Good solution Lynn. For some reason, I was thinking that the termcd values were not all known, hence the need for a pivot as I was actually thinking of...
May 19, 2008 at 4:25 pm
DBCC FREEPROCCACHE removes the stored execution plans from cache. I don't think this actually 'frees' memory from the SQL Server process. If you've read otherwise; please post the...
May 19, 2008 at 4:01 pm
The query to pull back the data with the aggregate values is quite simple.
SELECT Unique_ID, tempcd, COUNT(*)
FROM TableA
WHERE calldate > DATEADD(dd,-7,GETDATE())
GROUP BY Unique_ID, tempcd
It looks, though, like you...
May 19, 2008 at 3:10 pm
Mike,
Here's a good link that'll help you get better help with your questions.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 19, 2008 at 2:59 pm
This may be a silly question, but does the Addresses table have an IDENTITY column?
May 19, 2008 at 1:44 pm
Enterprise Manager is not a user tool. It is an administration tool. Don't give a plain-Jane user EM.
May 19, 2008 at 1:34 pm
SQL Server will grab as much memory as it can (up to the sp_configure 'max server memory (mb)' setting). It will not release it without re-starting the service. ...
May 19, 2008 at 1:32 pm
You must drop the FK and then add it again after the TRUNCATE.
May 19, 2008 at 1:28 pm
What Antonio has posted is as good of an answer as you'll get without us knowing more about your tables. Since you're a new poster, check this link out...
May 19, 2008 at 12:23 pm
Or, you could use QA and run a sp_configure:
sp_configure 'max server memory (MB)', 1024
GO
RECONFIGURE WITH OVERRIDE
May 19, 2008 at 12:16 pm
Just an observation here, but why not just leave the GUID value alone when you move the row to another table? Wouldn't this help you with relating the data...
May 19, 2008 at 12:01 pm
What problem does the blank line cause you?
May 19, 2008 at 11:49 am
Viewing 15 posts - 1,771 through 1,785 (of 3,232 total)