Viewing 15 posts - 18,046 through 18,060 (of 19,560 total)
I agree that this seems like an effort in the wrong direction. Consolidating these tables, based on limited information, does not seem to be a good idea.
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
January 19, 2010 at 9:33 am
Either the browser or connectivity on the OPs end.
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
January 19, 2010 at 8:43 am
The question has been updated and does read better now. Unfortunately, Hugo's point is valid - thus making the QOD answers less than accurate.
Maybe a rewording of the question...
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
January 19, 2010 at 8:41 am
True it is that work is prohibiting a lot of thread activity. I wonder also if there is some interference from New Years resolutions and goals too. Everybody...
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
January 19, 2010 at 8:29 am
suan (1/19/2010)
thanks for the prompt reply.few more questions
1) my organisation is implementing firewall, will the default dynamic port assigned to the named instance will be block as well?
Typically yes....
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
January 19, 2010 at 8:23 am
The difference I see is that your First Index is using an Index seek. The include columns are pulling in the data for the full query.
The second index 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
January 19, 2010 at 12:37 am
I think that knowing the business, trends, data, and database are integral in determining if a less normalized approach is necessary. A fully normalized database is not always 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
January 19, 2010 at 12:20 am
Thank you for this article. It is a nice demonstration of another reason why one should avoid the use of
Select *.
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
January 18, 2010 at 11:52 pm
Just backing up what Steve said. 1 IP address, multiple ports.
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
January 18, 2010 at 10:39 pm
hydbadrose (1/18/2010)
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
January 18, 2010 at 10:16 pm
Is the firewall enabled on the Vista host?
When trying to connect are you trying to use the vista\instance or vista,1433 method?
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
January 18, 2010 at 9:45 pm
What is your VM (Virtual PC/Server or VMWare)? Virtual PC/ Server allows the NIC to be seen back and forth between the host and VM. It seems like...
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
January 18, 2010 at 6:38 pm
halifaxdal (1/18/2010)
These days, I constantly receive message saying this forum is down, is it being attacked now? why this is happening so often? it seems only forum is affected.
Nothing to...
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
January 18, 2010 at 6:36 pm
You're 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
January 18, 2010 at 5:33 pm
Michael Valentine Jones (1/18/2010)
Stay away from #2. That's an EAV (Entity/Attribute/Value) model.
Hmmm...And I thought EAV meant Extremely Abominable Virus 😀
In practical terms, what you get are nightmarish queries 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
January 18, 2010 at 3:17 pm
Viewing 15 posts - 18,046 through 18,060 (of 19,560 total)