Viewing 15 posts - 1,591 through 1,605 (of 7,504 total)
Can you include sample data for the [AISPositionsCurrent] table ?
November 22, 2011 at 5:42 am
Dev (11/22/2011)
Cadavre (11/22/2011)
Repost.Probably should have just asked Steve to move the original (when he gets back) if you thought it was better suited here.
In fact I...
November 22, 2011 at 4:18 am
Why don't you just directly perform the update ?
What's inside the function dbo.GetZoneBlockCount ?
November 22, 2011 at 4:16 am
Did you set the upper limit for SQLServer am to be used ?
sp_configure 'max server memory' --, 13500 show the current value
sp_configure 'max server memory', 13500
With a 16GB server I...
November 22, 2011 at 3:38 am
Keep in mind columns with the identity property are meant to generate their own value in a given sequence.
(check books online for seed and increment)
However - as replied by the...
November 22, 2011 at 2:39 am
I don't get the combination of your previous two replies :crazy:
As long as I have enough space, I don't care about it during any migration.
It may indeed consume your resources....
November 19, 2011 at 2:22 am
did you specify the proxy account for the job step ?
November 18, 2011 at 6:48 am
Did you play around with the Microsoft Migration Assistant for Oracle ( to sqlserver ) ?
Always nice to give it a try .... this is free MS software 🙂
Have a...
November 18, 2011 at 6:47 am
Here's an alternative using alerts ...
help to tighten use of cmdshell or sp_start_job[/url]
You could also set up a SSB solution for it.
November 18, 2011 at 6:36 am
You'll have to shink the current file(s) because, as you state, you didn't configure your luns big enough to host that size. ( Which is IMHO awkward )
Check you current...
November 18, 2011 at 12:12 am
Keep. In mind that only makes. Sense for tables having a clustering index and for non-clustering indexes.( reindex)
November 17, 2011 at 1:56 pm
Did someone use two single quotes in stead of double quotes ?
November 16, 2011 at 1:45 pm
It depends.
For tables that are designed to not being referred to by other tables, a PK may not make sence.
That is a design issue.
However, it is advised a table has...
November 8, 2011 at 3:07 am
Correct George.
This is the ref .. http://technet.microsoft.com/en-us/library/ms179301(SQL.90).aspx
November 1, 2011 at 2:42 pm
Viewing 15 posts - 1,591 through 1,605 (of 7,504 total)