Viewing 15 posts - 28,276 through 28,290 (of 49,552 total)
Grant Fritchey (1/21/2011)
You didn't specify not today... Of course, if you had asked for one today, you know that wouldn't have been possible.
Silly me. I thought specifying monday morning ruled...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 5:11 am
Brandie Tarvin (1/21/2011)
GilaMonster (1/21/2011)
5 min later meeting request...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 4:58 am
Mail I sent earlier to my PM: "Please arrange a meeting monday morning with the business owner so that we can discuss <stuff>"
5 min later meeting request arrives. For 2pm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 4:44 am
If it was deleted recently it may be in the default trace. Otherwise no. If you want audit info, you have to put something in place to capture and store...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 3:46 am
A state of RESTORING means that there was a backup and that it was restored WITH NORECOVERY
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 3:45 am
Don't use syscacheobjects. It's deprecated, included only for backward compatibility and it's very limited.
The DMVs you'll need for this are
sys.dm_exec_cached_plans (one row per plan)
sys.dm_exec_query_stats (one row per statement in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2011 at 3:44 am
Don't put much, if any, meaning into the queue length counters (as the podcast I linked to explained) as they are near-meaningless on SAN or other shared storage arrays. In...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 3:12 pm
You cannot mirror between servers of different versions. They must be the same version (both SQL 2008 R2)
And the version of management studio you are using is SQL 2005. You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 1:27 pm
Craig Farrell (1/20/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 12:54 pm
INSERT INTO <Destination Table> (<Column List>)
SELECT <Column List>
FROM <Source Table>
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:47 am
Run the following and post the results.
SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('Products') ORDER BY name
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:42 am
Again I think you misspelt it. You have CustomFeild4 in your query, I doubt it's misspelt in the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:32 am
Justin 17041 (1/20/2011)
Your SQL is invalid: The multi-part identifier "OrderDtails.ProductCode" could not be bound.
That's because you misspelt it. The table is not OrderDtails, it's OrderDetails
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:20 am
Precisely.
When you build up the from clause, you can only use columns from tables that you've already specified, so make sure you get the order of the tables correct. In...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:19 am
Are you reading my posts?
You need this form of query. All you have to do is fill in the join conditions, fill in the where clause and the order by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2011 at 11:04 am
Viewing 15 posts - 28,276 through 28,290 (of 49,552 total)