It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.
2011-09-16
2,528 reads
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
2011-09-09
4,876 reads
Comments posted to this topic are about the content posted at http://www.databasejournal.com/features/mssql/article.php/343204
2004-11-09
2 reads
Hi!Using my trusted login (it has sa privileges) I created new column (bit, allow NULLs) for a table. After that only me can see it and only with EM, even after reconnecting to the server. There is no any records for this column in syscolumns table.Wonder what had happen!?!Thanks.
2004-09-20
22 reads
The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column will be filled with 'N' automatically as such.Regards
2004-09-07
Connect to SQL with QA Rename the windows install issue an sp_dropserver (old name) go sp_addserver (newname), local And reboot. Should be good to go.
2004-08-13
OK. If we change SQL port 1433 to something else(how to choose what the new port should be?)then I suspect we need to change all our database connection strings in all our applications.I've never done this before - to specify port number in your database connection string. We have a couple of Cold Fusion applications, […]
2004-06-11
Microsoft has a procedure described here that I've used for this before when moving databases that works well: http://support.microsoft.com/default.aspx?scid=kb;en-us;298897&Product=sqlHope this helps.
2004-06-10
bcp data out, then bcp into temptable using -F, -L parameters.
2004-04-05
I took Jack's code, modified it with the changes suggested by Antares and I get this:Create FUNCTION dbo.udf_GetEMpsBYManager ( @empid char(6) ) RETURNS @table_variable TABLE (employeeid char(6), sn varchar(15), givenname varchar(25), mail varchar(50) ) AS BEGINDeclare @temp Table (employeeid char(6)) Declare @rows IntInsert Into @temp Select Distinct employeeid From directory Where higmanagerempid […]
2004-03-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers