Viewing 15 posts - 28,306 through 28,320 (of 49,552 total)
GSquared (1/20/2011)
... Object Data Base Connections (ODBC)
Well to start, ODBC does not stand for Object Data Base Connection. Buzzword scrabble time.
plus expert level understanding of web protocols such as...
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:23 am
chaingang.174 (1/20/2011)
My Project Manager told me that I should Maintain a document regarding the datatypes which should be used as performance and durability in mind ..
Data types don't have any...
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:05 am
Ferguson (1/20/2011)
Where I continue to resist however is the whole generalist idea. They must be out there.
Sure they are. However you've indicated you want hotshots. Top skills. You're...
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 6:34 am
Sachin Nandanwar (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 5:44 am
Brandie Tarvin (1/20/2011)
I saw a job description once that very specifically asked for 5 years experience in SQL 2005.That was in May of 2005.
5 years experience on a product that...
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 5:40 am
School homework? Odd request certainly.
Pick the most appropriate data type that's as small as possible but not smaller.
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 5:39 am
mohammed moinudheen (1/20/2011)
If the deletion happened recently, may be you could find what you are looking for.
The default trace does not store DML actions (select, insert, update, delete).
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 4:27 am
Ferguson (1/19/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 3:41 am
JayK (1/19/2011)
My query, which returns 60830 rows went from an execution time of 11 mins 05 secs to 23 secs.
:w00t: That's excellent. Glad to hear.
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:22 am
nvarchar is not a LOB data type. nvarchar(MAX) is. I don't know how the script works, but it must be misidentifying that this table has a LOB column
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 19, 2011 at 3:46 pm
Craig Farrell (1/19/2011)
Anyone know what brand of cookies (or cigars) the current MVPGA likes? 😉
Bribing a committee is an expensive proposition. :hehe:
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 19, 2011 at 3:27 pm
Craig Farrell (1/19/2011)
Side note: How does one become a MS SQL MVP? My google-fu is failing miserably.
You get a nice little email from MS on the first day of...
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 19, 2011 at 3:10 pm
Not for SQL backups. Not if you actually want them restorable.
As for system backups, no idea, I'm not a system administrator.
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 19, 2011 at 3:08 pm
Justin 17041 (1/19/2011)
JOIN OrderdetailsON orders.orderid = orderdetails.orderid
WHERE Ordersdetails.ProductCode Like ('Upgrade%')
ORDER BY Orders.Salesrep_Customerid ASC
Should it be in instead of Like because i need it to select all the product...
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 19, 2011 at 2:54 pm
The clustered index IS the table. It has at the leaf level all the columns in the table. Hence you added a LOB column to the clustered index (which is...
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 19, 2011 at 2:09 pm
Viewing 15 posts - 28,306 through 28,320 (of 49,552 total)