Viewing 15 posts - 28,291 through 28,305 (of 49,552 total)
The format of a SELECT is...
SELECT <column list>
FROM <table list WITH joins>
WHERE <conditions>
GROUP BY <column list>
HAVING <Conditions>
ORDER BY <Columns>
All but the SELECT are optional. The order cannot be changed and...
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 10:50 am
Your permissions have nothing to do with anything. It's the permissions of the account that SQL runs under that's important.
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 10:41 am
Please, please look at the code and explanation I've posted for you twice
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 10:40 am
ColdCoffee (1/20/2011)
Remove the , and replace it with AND like this
Inner Join Products
ON Products.Productname = OrderDetails.ProductName and
Products.ProductCode = OrderDetails.ProductCode
Except that there's no...
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 10:39 am
Why is the product name in the order details? It shouldn't be there, it should only be in the products table. The product code only should be in the order...
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 10:37 am
GilaMonster (1/20/2011)
FROM...
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 10:36 am
No. A join needs an ON to say which columns are matched in the join.
I suspect that the tables are just referenced in the wrong order in the FROM clause....
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 10:22 am
Does SQL have full control over the folder (or just read)? Compressed folder?
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 10:21 am
sqldba_icon (1/20/2011)
My guess is there is a procedure which is executed like 100 times day and is creating a execution plan everytime.
Shouldn't be. Unless there's something forcing recompiles, something...
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 9:56 am
Let me see if I have this straight, you want to export a really large database to XML, producing a really, really large XML file, then you want to make...
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 9:49 am
Without an order by you can say nothing about the order of the returned result set. It'll depend on the plan the optimiser picks, the scan method the storage engine...
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 8:36 am
Yes, they're probably stored out of row and if they are, reading them (the LOB column, not the rest of the row) incurs additional reads.
That said, if you need them,...
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 8:22 am
No. LOB data types are:
TEXT (deprecated)
NTEXT (deprecated)
IMAGE (deprecated)
VARCHAR(MAX)
NVARCHAR(MAX)
VARBINARY(MAX)
XML
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 7:59 am
http://sqlinthewild.co.za/index.php/2009/02/14/do-you-know-how-to-use-perfmon/
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 7:35 am
Grant Fritchey (1/20/2011)
My most recent post was about why do log files fill up. Believe me, other people have posted about it.
A topic I'm in the middle of writing an...
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 7:25 am
Viewing 15 posts - 28,291 through 28,305 (of 49,552 total)