- a simple and handy script that finds what differences might exists between the fields in your database that have the same name.I was wondering why my execution plans where different for tables with the same field names and the same indexes,statistics etc... because the syetem was converting my fields in the WHERE statement. - […]
2003-06-08
114 reads
2 steps:step 1 => create a table in master database called BlockCheckstep 2 => create the stored procedure in master called BLOCK_CHECK @database_name varchar(20)What SP does:- it gets the spid that is blocked + info about it (like what it does at the moment it is blocked)- it gets the spid that acts as a […]
2003-06-05
729 reads
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Comments posted to this topic are about the item Learning From Breakage
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Comments posted to this topic are about the item Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers