Your SQL Server has a case insensitive collation, but you need a case sensitive join? Do you know what happens? There are a couple options but do you know the performance implications of using each? Or a way to mitigate the performance degradation that can result?
It's not often that we toot our horn, but SQLServerCentral.com was chosen as the feature site by GotDotNet.com, one of Microsoft's premier .Net sites. Check it out!
Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.
Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.
Microsoft began taking sign ups for participation in the SQL Server 2005 Beta 2 program this week at its Microsoft TechEd show here as the long-awaited test version of the product gets close to availability.
Apex SQL Tools has released Apex SQL Edit 3.0, database Tools for database editing. Apex SQL Edit is an integrated development environment (IDE) for SQL Server including powerful editing capabilities, deployment capabilities, full integration with Visual Source safe as well as SQL Server Reporting services and much more.
Microsoft Corp. is planning to deliver updates to its Exchange Server product every two years and is considering a similar move to deliver SQL Server updates in a more timely manner, company officials said at the TechEd 2004 conference.
SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Comments posted to this topic are about the item Are You Working More Hours?
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers