Viewing 15 posts - 3,361 through 3,375 (of 6,676 total)
MysteryJimbo (2/24/2011)
I've had this once before and found the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 24, 2011 at 2:56 pm
More likely it is their way of trying to reduce log usage during index rebuilds. They probably have code written that switches to simple recovery, rebuilds the index and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 24, 2011 at 2:48 pm
danschl (2/24/2011)
And in development, so of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 24, 2011 at 2:40 pm
Yes, that is correct - you cannot change the default trace.
I am a bit surprised that you don't have data any further back. I just checked one of my...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 23, 2011 at 3:08 pm
There is a standard report that you can use to see these changes. The report is the schema change history report - just run that and you will see...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 22, 2011 at 8:26 pm
hemul (2/21/2011)
http://msdn.microsoft.com/en-us/library/ms190488(v=SQL.90).aspx
The database cannot be made smaller than the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 21, 2011 at 5:28 pm
There really is no way to tell SQL Server to load a database into memory. SQL Server loads data into the buffer cache when it is accessed the first...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 21, 2011 at 2:16 pm
If you truly think this is a bug (it isn't), then put in your issue at Connect and let Microsoft know.
Now, the reason this is not a bug is because...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 21, 2011 at 1:36 pm
Which is exactly what COALESCE or ISNULL will do for you. Sorry, mis-quoted and it should be:
SELECT coalesce(2.resellername, 'Other')
The above can be re-written using a case expression, if you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 19, 2011 at 2:37 pm
Lookup COALESCE and ISNUL in Books Online:
SELECT coalesce(1.resellername, 'Other') As resellername, ...
FROM ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 19, 2011 at 2:03 pm
Thought of another thing to check - verify that you have enabled both TCP/IP and named pipes in SQL Server Surface Area configuration.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2011 at 8:22 pm
That is definitely weird - there must be something with that instances configuration.
Some other things I would check, but honestly I don't know if any of these would cause this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2011 at 8:19 pm
gchaimovitz (2/16/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2011 at 4:17 pm
THE-FHA (2/16/2011)
so what you must do is deleted the services as follows:-
ON THE COMMAND PROMPT RUN THESE COMMANDS.
sc delete MSSQLSERVER
run sc delete commdand for all...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2011 at 4:11 pm
What your process ran into is a deadlock. When SQL Server sees a deadlock happen, it chooses one of the processes as the deadlock victim and terminates it.
A deadlock...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 16, 2011 at 4:04 pm
Viewing 15 posts - 3,361 through 3,375 (of 6,676 total)