Viewing 15 posts - 2,161 through 2,175 (of 19,560 total)
Raghavendra Mudugal (8/21/2014)
TomThomson (8/21/2014)
twin.devil (8/21/2014)
Just for the information.Becuase #table names max length is only 116 characters in SQL Server 2008 r2. its also valid of SQL SERVER 2012.
It's valid...
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
August 22, 2014 at 12:09 pm
gbritton1 (8/22/2014)
also means:- basketball is my life
- Bureau international de Métrologie légale
...and others
Those two are just Perfect!!
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
August 22, 2014 at 12:02 pm
Grant Fritchey (8/22/2014)
SQLRNNR (8/22/2014)
In other news, what does everybody think of the Mythbusters news from last night?
I hadn't heard, but now that I know... I'm bummed. They made the show...
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
August 22, 2014 at 8:24 am
In other news, what does everybody think of the Mythbusters news from last night?
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
August 22, 2014 at 7:59 am
Jack Corbett (8/22/2014)
SQLRNNR (8/22/2014)
Ed Wagner (8/22/2014)
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
August 22, 2014 at 7:57 am
Koen Verbeeck (8/22/2014)
SQLRNNR (8/22/2014)
Ed Wagner (8/22/2014)
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
August 22, 2014 at 7:55 am
Ed Wagner (8/22/2014)
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
August 22, 2014 at 7:46 am
Perry Whittle (8/22/2014)
Duran (8/21/2014)
I'm not doing T-Log backups (yes I know, lets leave that for now!).Thanks in advance.
D.
Are you saying you've disabled the log shipping agent backup jobs??
I hope that...
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
August 22, 2014 at 7:41 am
Hany Helmy (8/21/2014)
DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;
DBCC CHECKDB WITH PHYSICAL_ONLY; -- Best Practice
So I had to read the documentation carefully, then...
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
August 21, 2014 at 7:36 am
This question highlights another great example of bad (conflicting) documentation.
Within the same documentation one will find both of the following statements.
DBCC CHECKDB does not examine disabled indexes.
And
Unless NOINDEX is specified,...
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
August 20, 2014 at 8:32 am
quackhandle1975 (8/20/2014)
Also...
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
August 20, 2014 at 7:43 am
smtzac (8/19/2014)
There is a log file 100 GB. New transaction occurs and it shows 125 GB log file 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
August 19, 2014 at 12:34 pm
Yes. Here is an article on that.
http://msdn.microsoft.com/en-us/library/ms159762.aspx
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
August 19, 2014 at 12:25 pm
I mean, does the test_create table that you provided represent
REVENUE.MONTHLY_VOUCHER_NEW
or
SUBSCRIBER.DAILY_DV_NEW PARTITION
or
Test_Table
from your original query that you posted?
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
August 19, 2014 at 12:20 pm
Which table is test_create supposed to represent?
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
August 19, 2014 at 12:09 pm
Viewing 15 posts - 2,161 through 2,175 (of 19,560 total)