Viewing 15 posts - 1,216 through 1,230 (of 1,409 total)
For my knowledge, there is no such event. When the service is (going) down or hangs it is obvious no scripts can be executed.
I think you should act on entries...
April 8, 2009 at 2:23 am
You can see in the execution plan that both options are executed alike.
But only use DISTINCT or GROUP BY when required, because they can cause real performance hits.
April 3, 2009 at 6:02 am
In my experience data is given without being obfuscated or not given at all. There is nothing in between. But I think it is something that the market will require...
March 10, 2009 at 6:11 am
Mike John (3/4/2009)
2009-09-02 17:30:00.000 -- which is exactly what you will see if you are configured for a UK date format. ie the dateadds behave as...
March 4, 2009 at 7:11 am
john.arnott (3/3/2009)
For one additional degree of difficulty: What's the result from this query?
select DATEADD(HOUR,5,DATEADD(MINUTE,-59,'2009-02-09 12:34:56.789'))
a) 2009-02-09 07:34:57.789
b) 2009-02-09 16:35:56.789
c) 2009-02-09 16:33:56.790
d) 2009-02-09 16:35:56.790
I think it's answer B. Microseconds are...
March 4, 2009 at 7:08 am
Does your account has the required rights? And is the import transaction committed?
February 26, 2009 at 8:44 am
Check if you can access the remotely created DB with the credentials used by the connection using SSMS.
I guess you must create a user on the new database (and/or reconnect...
February 24, 2009 at 7:31 am
Sakthivel Chidambaram (2/24/2009)
So SQL 200 to 2005 migration is possible? 😀
Migration from SQL 2000 to a new version (2005 or 2008) is possible, but if you want to migrate from...
February 24, 2009 at 7:23 am
ALZDBA (2/11/2009)
(N)Text needs to be replaced with (N)varchar(max). Those can contain up to 2GB of data (1 for...
February 11, 2009 at 5:49 am
As ALZDBA allready told, 8060 is the maximum number of characters that fit in NVARCHAR. If you really want to convert the NTEXT you must limit the amount of data....
February 11, 2009 at 4:06 am
Perhaps you can find the solution on http://msdn.microsoft.com/en-us/library/ms161561.aspx.
Pay special attention to step 10 from "configure and run the package" on that page!!
February 11, 2009 at 3:29 am
Can you post the error message?
And did you check the account of the SQL Agent service? Is it the same as the account compared to the server that executes correct?
February 11, 2009 at 3:19 am
To import data from other sources you can use SSIS. Any issues that can occur depend on your systems and needs. There is no way to tell you about it...
February 10, 2009 at 6:33 am
I suggest to use Windows Performance counters for CPU, memory and disk-IO usage. Run it for a day or a week to get clear knowledge of the servers performance. This...
February 10, 2009 at 6:19 am
William Vach (1/9/2009)
I don't believe that you can move the mssqlsystemresource (resource) database.
I agree with William: I thought the question is which system databases can be moved. Therfor I didn't...
January 9, 2009 at 6:39 am
Viewing 15 posts - 1,216 through 1,230 (of 1,409 total)