Viewing 15 posts - 1,696 through 1,710 (of 2,647 total)
sqlfriends (2/15/2012)
SQLKnowItAll (2/15/2012)
February 15, 2012 at 10:57 am
I didn't say that the only alerts you needed are cpu and memory, what I said was that it wil depend on your entire architecture. Hopefully your OPs team is...
February 15, 2012 at 10:52 am
The types of performance alerts that you are mentioning are really not necessary until a problem occurs. If you monitor the error log regularly, you can pretty much see...
February 15, 2012 at 10:38 am
They are groups. Notice when you look at the icons in SSMS they are not a single person, they are 2. So, a domain account that gets added...
February 15, 2012 at 10:35 am
Are you saying that you are running this "report" in SSMS? Or are you exporting to a file from SSRS?
February 15, 2012 at 10:12 am
ScottPletcher (2/15/2012)
February 15, 2012 at 7:58 am
Jeff Moden (2/14/2012)
SQLKnowItAll (2/14/2012)
ScottPletcher (2/14/2012)
Be careful with phrasing: MSDN doesn't say it doesn't work, they say it's not guaranteed to work.
I believe that in this case, the clustered index is...
February 15, 2012 at 6:11 am
@lutz
Your scenario 1 most certainly requires an unlimited CAL license if you cannot account for all devices. This is one of those "indirect" scenarios that should have a socket...
February 15, 2012 at 5:59 am
When talking to Microsoft about this, they said any person or device directly or indirectly touching the SQL Server requires a CAL. For example, if a website touches SQL Server...
February 14, 2012 at 3:22 pm
Glad to hear you solved the issue, but could you provide us with execution plans from the original statement's insert versus just the select. Its nice that you "maintain"...
February 14, 2012 at 2:10 pm
In that case, I would reinstall or repair SSIS.
February 14, 2012 at 2:04 pm
ScottPletcher (2/14/2012)
Be careful with phrasing: MSDN doesn't say it doesn't work, they say it's not guaranteed to work.
I believe that in this case, the clustered index is on the identity....
February 14, 2012 at 1:15 pm
Did you try to run the package again? You are not giving me enough details about what you are trying and what is happening. You should not worry about the...
February 14, 2012 at 12:56 pm
Need more info. Do you reference linked servers?
February 14, 2012 at 12:45 pm
ScottPletcher (2/14/2012)
When used together with a SELECT...INTO statement to insert rows from another source, ...
I take that to mean what it explicitly says -- if you do SELECT ... INTO...
February 14, 2012 at 12:31 pm
Viewing 15 posts - 1,696 through 1,710 (of 2,647 total)