Viewing 15 posts - 13,651 through 13,665 (of 19,560 total)
My primary concern would be that you have an application config file on the database server. Typically you would not want to host the application on the same server...
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
June 9, 2010 at 7:33 pm
Your 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
June 9, 2010 at 7:11 pm
It is related to the sys schema. The sys schema is the owner of many system objects (dmvs for instance).
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
June 9, 2010 at 6:00 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
June 9, 2010 at 5:42 pm
audracmckay (6/9/2010)
hmm. no I'm on 2005 too. Sorry. I guess i didn't notice that either!
That's all good. Solutions for both types are posted. The SQL 2000 version will...
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
June 9, 2010 at 5:30 pm
Here is a SQL 2000 version
Declare @CounterTable Table (Table_Name Varchar(50), NumOccurrences int)
Insert into @CounterTable (Table_Name, NumOccurrences)
SELECT Table_Name
,COUNT(Table_Name) AS NumOccurrences
FROM INFORMATION_SCHEMA.Columns
GROUP BY Table_Name
HAVING ( COUNT(Table_Name) >= 0 )
Select Count(Table_Name) as ColCount,...
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
June 9, 2010 at 5:26 pm
Are you truly on SQL 2000?
Here is a solution for SQL 2005 (sorry just noticed the forum group after having worked the solution - will post a sql 2000 solution...
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
June 9, 2010 at 5:23 pm
It will depend on how you want to present the data on the website. Both SSRS and OLAP can help you with that - but the presentation of 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
June 9, 2010 at 5:17 pm
Put one more feather in that cap. I do it for the same reasons as Grant mentioned. As Elliot said, proceed cautiously and make sure it is well...
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
June 9, 2010 at 5:14 pm
Looks like the query is working, is there something that it is not doing that you would like it to do?
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
June 9, 2010 at 5:09 pm
SSRS and OLAP would be useful in performing web analytics.
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
June 9, 2010 at 5:07 pm
Yes, rerun setup and you will be able to install the tools.
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
June 9, 2010 at 5:05 pm
I'm with Steve on this. I don't understand what your question is. Could you elaborate?
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
June 9, 2010 at 5:03 pm
Sounds like a good plan. Good luck.
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
June 9, 2010 at 5:01 pm
Two options
Create a cursor that does essentially the same thing I just showed you.
or
Run that script, review the commands, and then set it up in a job to execute 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
June 9, 2010 at 4:46 pm
Viewing 15 posts - 13,651 through 13,665 (of 19,560 total)