Viewing 15 posts - 6,436 through 6,450 (of 19,560 total)
To restate what the others have said:
These questions are typical interview questions.
These questions are also typical homework questions.
These questions can be easily found in BOL and google.
We don't typically answer...
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
April 11, 2012 at 10:38 am
How many meetings are conducted on the GOLF course?
Certainly that can be productive too, right?
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
April 11, 2012 at 9:49 am
Did he by chance refresh ssms after you granted those permissions?
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
April 11, 2012 at 9:43 am
drew.allen (4/11/2012)
Please do not create duplicate posts for the same topic. It fragments the replies. Please respond in this thread. http://www.sqlservercentral.com/Forums/Topic1281038-392-1.aspxDrew
Beat me to it.:cool:
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
April 11, 2012 at 9:25 am
SQL_NuB (4/11/2012)
the URL isn't being stored, its just a string that is being pulled out of the table and then wrapping a link around it
Understood. I was just saying...
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
April 11, 2012 at 9:13 am
I see nothing wrong with that method.
Some databases also store url in the database.
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
April 11, 2012 at 8:45 am
I think we had a very similar question within the past few months.:cool:
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
April 11, 2012 at 8:43 am
crookj (4/11/2012)
jcrawf02 (4/11/2012)
chaosTheory
Bang
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
April 11, 2012 at 8:34 am
K - so it seems that you are experiencing a memory pressure problem multiple times throughout the day. With this being a VM, and since you have 4GB allocated...
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
April 10, 2012 at 8:39 pm
The next time this happens, see if your Page Life Expectancy drops dramatically.
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
April 10, 2012 at 4:30 pm
sqlfriends (4/10/2012)
spatial data could be what they use, he is a GIS analyst.So we can ignore the message? or it means we do have memory pressure.
Well, what is your max...
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
April 10, 2012 at 2:47 pm
Grant Fritchey (4/10/2012)
Stefan Krzywicki (4/10/2012)
Jack Corbett (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
SQLRNNR (4/10/2012)
Stefan Krzywicki (4/10/2012)
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
April 10, 2012 at 1:26 pm
Here are a few worthwhile books:
http://www.amazon.com/Applied-Microsoft-Server-Reporting-Services/dp/0976635313
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
April 10, 2012 at 1:09 pm
Sounds like you have a value in your table that when combined with the exp function you exceed the bounds of the float datatype.
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
April 10, 2012 at 1:04 pm
What is the datatype of filed?
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
April 10, 2012 at 12:56 pm
Viewing 15 posts - 6,436 through 6,450 (of 19,560 total)