Viewing 15 posts - 5,956 through 5,970 (of 19,560 total)
Koen Verbeeck (7/12/2012)
You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked Server menu?
Koen, have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 7:21 pm
down
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 12:46 pm
dan-572483 (7/13/2012)
If SQL is clustered it should be shut down in Cluster Manager only. If it is not clustered, I prefer to use SQL Server Configuration Manager.
I agree, in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 11:15 am
Is it visible in IE?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 9:28 am
mbova407 (7/13/2012)
Rich Weissler (7/13/2012)
Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 9:28 am
capn.hector (7/12/2012)
SQLRNNR (7/12/2012)
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
untill you run into a production system using sql 7 because...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 3:51 pm
GilaMonster (7/12/2012)
SQLRNNR (7/12/2012)
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 3:48 pm
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. Though the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 3:25 pm
This one
Database master: IO is frozen for snapshot
or this one
Database MF20: IO is thawed
Those can be caused by any number of backup agents (such as Windows NT backup).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 2:54 pm
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 2:51 pm
I don't see an error in that log output. I must be missing it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 2:29 pm
you are welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 1:22 pm
Lynn Pettis (7/12/2012)
SQLRNNR (7/12/2012)
Never heard of them and would not put too much trust into sites that promote "real answers to real questions"
Don't we offer real answers to real questions?...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 1:00 pm
CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));
GO
EXECUTE sp_msforeachdb 'USE [?]; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)
SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files where DB_NAME(database_id) = ''?'''
SELECT DB_NAME(database_id) AS DBName,physical_name,CONVERT(DECIMAL(14,2),size)/128 AS FileSize, growth
,CONVERT(DECIMAL(14,2),max_size)/128 AS...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 12:57 pm
Never heard of them and would not put too much trust into sites that promote "real answers to real questions"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 12:52 pm
Viewing 15 posts - 5,956 through 5,970 (of 19,560 total)