Viewing 15 posts - 19,096 through 19,110 (of 19,560 total)
DBAgal (11/18/2009)
Matt Miller (#4) (11/18/2009)
DBAgal (11/18/2009)
Typically, would something like email addresses/phone numbers be ok to store in a databases in the DMZ???
Would there be a downside to that data getting...
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
November 18, 2009 at 12:32 pm
Read this Blog Post on Nolock
Q. Will nolock provide a performance boost?
A. Yes it could, as well as provide unexpected results.
Read the article, it outlines some precautions with...
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
November 18, 2009 at 12:17 pm
Lynn Pettis (11/18/2009)
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
November 18, 2009 at 12:07 pm
Are you able to connect in Management Studio using the IP?
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
November 18, 2009 at 10:56 am
And to combine the two:
With IndexSize as (
SELECT objectname = object_name(object_id) ,reservedpages = SUM (reserved_page_count),usedpages = SUM (used_page_count)
,pages = SUM (
CASE
WHEN (index_id < 2)
THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
ELSE lob_used_page_count...
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
November 18, 2009 at 10:46 am
With IndexSize as (
SELECT objectname = object_name(object_id) ,reservedpages = SUM (reserved_page_count),usedpages = SUM (used_page_count)
,pages = SUM (
CASE
WHEN (index_id < 2)
THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
ELSE lob_used_page_count + row_overflow_used_page_count
END
)
,srowCount = SUM...
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
November 18, 2009 at 10:29 am
Yes, you will need to verify that 1335 is permitted through your firewall. You will also need to verify that the server is listening on 1335. Verify 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
November 18, 2009 at 10:10 am
Liger - it's a mythical creature
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
November 18, 2009 at 9:58 am
It is possible to put a database in the dmz, as long as the data is disclosable (application centric), and then firewall it off. Typically, customer data should not...
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
November 18, 2009 at 9:57 am
Are you trying to create a scenario where every combination must be inserted into the database in pairs? And if the combination is not paired then it should not...
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
November 17, 2009 at 5:55 pm
this might be of help:
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
November 17, 2009 at 5:50 pm
Bru Medishetty (11/17/2009)
SELECT [Name] FROM MASTER..SYSDATABASESShould give the list of all Databases in that Server (Instance)
To get it in all Servers, I am not aware of this, in SQL...
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
November 17, 2009 at 1:18 pm
Jack Corbett (11/17/2009)
Jeff Moden (11/17/2009)
Alvin Ramard (11/17/2009)
Grant Fritchey (11/17/2009)
Paul White (11/17/2009)
LMGTFY version 2.0:I'm confused now. Shouldn't that be LMBTFY?
Let
Me
Be
The
First
Yeller??
BWAA-HAA!!! You have too much time on your hands, Alvin. 😛
Is...
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
November 17, 2009 at 1:16 pm
Chad Crawford (11/17/2009)
I'll throw my hat in the ring in your favor. I can't argue as eloquently as Lynn, but I'll say this - you are...
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
November 17, 2009 at 1:11 pm
One possibility is if you have MSDN. You could download foxpro from the MSDN site.
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
November 17, 2009 at 11:08 am
Viewing 15 posts - 19,096 through 19,110 (of 19,560 total)