Viewing 15 posts - 47,746 through 47,760 (of 49,552 total)
It's not so much that the syntax has changed, but that SQL is now permitted to ignore the Top 100% ... order by construct where it appears anywhere other than...
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 9, 2008 at 3:23 am
You can't modify the system objects.
You're probably best off writing your own query against the catalog views sys.columns, sys.types, sys.tables...
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 9, 2008 at 2:41 am
Select * from sys.databases where database_id > 4
The syztem dbs have IDs from 1 to 4, the user databases from 5 up. (The system resource db is an exception, but...
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 9, 2008 at 12:44 am
You can get the latest CTP on the Connect site (https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395)
It is beta software, so be careful where you install it.
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 9, 2008 at 12:42 am
It's a .net object that acts as a link between the connection and a data set. The adaptor gets told what the select, update, insert and delete
statements for 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 8, 2008 at 11:34 pm
miltiadis (1/8/2008)
There is also no link between professors and students
Which is fine if you don't need to know who taught which student. If you do, you'll have to...
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 8, 2008 at 11:25 pm
The event captures queries completing within procedures.
Start profiler, connect to a server (I would suggest for a good workload, use the production server. If you use anything else, 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 8, 2008 at 11:16 pm
Do your reals have decimal places?
If not, just query based on the range that the smaller data types can handle
Select * from Array_table where value between 0 and 127 --...
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 8, 2008 at 2:05 pm
SQL King (1/8/2008)
What's up with all those people that want dumps rather than studying hard for the exam?
Lazy perhaps. Seeking the quick and easy path.
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 8, 2008 at 1:42 pm
Steve Jones - Editor (1/8/2008)
Inside SQL Server is here: http://corporate.books24x7.com/home2.asp
Ooohhhhhh........ :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 8, 2008 at 1:40 pm
Try running profiler and capturing the SP:StmtCompleted event (under stored procedures). That will fire an event for each query in the stored proc. You're best off running profiler for a...
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 8, 2008 at 9:50 am
The inside SQL Server series are books, not online resources. They are very worth buying though.
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 8, 2008 at 7:04 am
The 2005 books online are excellent, and I strongly recommend the Inside SQL Server 2005 series, from Solid Quality Learning.
First one (Storage engine) was written by Kalen Delaney
Next 2 (T-SQL...
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 8, 2008 at 4:53 am
SQL 2005 ignores sorts in a view unless the number of rows is limited by a top statement.
Views shouldn't have sorts in them. The sort should only be done on...
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 8, 2008 at 3:16 am
If you really want to drive a DBA insane...
CREATE TABLE [[dbo.[[[.[,] (
[.[,[,] INT,
[Max([.[,[,)] VARCHAR(10)
)
GO
SELECT [.[,[,], [Max([.[,[,)] FROM dbo.[[dbo.[[[.[,]
Yes, it's valid.
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 7, 2008 at 11:19 pm
Viewing 15 posts - 47,746 through 47,760 (of 49,552 total)