Viewing 15 posts - 10,771 through 10,785 (of 19,560 total)
No - you should be able to see that port listening from remote and you should get a response when telnet to it. Something is blocking you from seeing...
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
March 24, 2011 at 3:38 pm
Is the windows firewall on the server disabled or running?
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
March 24, 2011 at 2:45 pm
Typically for something like this, you would need to use dynamic SQL.
You are also missing a single quote that may be affecting your query.
Here is something that may help 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
March 24, 2011 at 2:07 pm
Based on the abilities of compression and the version of SQL Server, you may want to look into an alternative method to compress it.
Also, I would look into changing 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
March 24, 2011 at 1:37 pm
Another option on that trace file is that the path to it may be too large. Try adjusting the variable size and see if that helps.
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
March 24, 2011 at 1:16 pm
What version and Service Pack? This should work.
Try the following and it should work as an example.
set showplan_xml on
go
select *
Into #testtemp
From sys.databases
go
set showplan_xml off
go
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
March 24, 2011 at 12:53 pm
Is the server firewalled off from the computer that is having problems connecting to it (without port number)?
Maybe a router/firewall in between the server and the desktop machine is 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
March 24, 2011 at 12:47 pm
It really depends. The better option would be to implement a routine that rebuilds or reorganizes the indexes based on fragmentation level. After the index maintenance then you...
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
March 24, 2011 at 12:41 pm
Thanks for the article.
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
March 24, 2011 at 12:34 pm
I find this editorial interesting in that I had a recent discussion concerning new car models that have wifi enabled in the car. The wifi in these cars 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
March 24, 2011 at 10:54 am
Thanks for 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
March 24, 2011 at 10:41 am
Steve Jones - SSC Editor (3/24/2011)
CirquedeSQLeil (3/24/2011)
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
March 24, 2011 at 10:14 am
Ray K (3/24/2011)
WOTD: zzzzzzzzzzzzzzzzzzzzzzzzzzz :doze:
sound advice
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
March 24, 2011 at 10:13 am
sqldba_icon (3/24/2011)
CirquedeSQLeil (3/23/2011)
You can read 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
March 24, 2011 at 10:03 am
As far as bad drivers goes, Las Vegas takes all of the bad habits from all over the country (including many from overseas) and combines them into one place.
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
March 24, 2011 at 7:47 am
Viewing 15 posts - 10,771 through 10,785 (of 19,560 total)