Ankur Vaish

How to make SSMS uppercase keywords

No, Management Studio does not have this native functionality in any version from 2005 -> 2016 CTP 3.2. You may want to check out 3rd party add-ins, like Mladen Prajdić's SSMS Tools Pack or Red-Gate's SQL Prompt, both of which have the capability to format a block of code, including automatically upper-casing…

SQL Server

Answered Apr 24, 2021 · 1.7K Views Read answer →

Why SQL server Filtered index is not used when a variable in WHERE condition?

A filtered index is an optimized nonclustered index especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table. Why SQL server Filtered index is not used when a variable in WHERE condition? The reason for that is, Indexes may…

SQL Server

Answered Apr 24, 2021 · 2.1K Views Read answer →

What is SQL Server’s unique index, per subset of data, based on values of another column?

Creating a function to ensure the uniqueness of each new email value, and call that function in a check constraint Create a trigger, and on each insert or update ensure that the email is not duplicate per customer Forget about the database at all, and make this part of the business in my application tier However, I…

SQL Server

Answered Apr 24, 2021 · 1.6K Views Read answer →

How to Download SQL server 2014 developer edition?

Yes, Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual Studio Dev Essentials members.Here are the steps to install SQL Server 2014 Developer Edition Once you have downloaded the iso file, go to the downloaded location and mount the iso file by double clicking it. Then…

SQL Server

Answered Apr 24, 2021 · 5.4K Views Read answer →

Filtered index is not used when the variable in WHERE condition

Filtered indexes can't use variables/parameters unless you're building your query with dynamic SQL so that the query ends up getting executed with a literal. A good article on the topic is Filtered Indexes and Dynamic SQL by Jeremiah Peschka. OR As Martin suggested, you could add WITH (RECOMPILE) to the query, but…

SQL Server

Answered Apr 24, 2021 · 1.5K Views Read answer →

When To Use Set vs. List In SOQL? Which one is better?

Here we have set vs list comparison below: Set vs List: Filter Speed If you can use Map.keySet(), you'll get a Set back in about 1/10th of the time versus a loop over those same records and adding all the values. Of course, the Map(List) constructor only works on Id, not on related ID values, which means you'd have to…

Salesforce

Answered Apr 24, 2021 · 2.0K Views Read answer →

How do we document databases in SQL server?

SQL Server Documentation The process of documenting a SQL Server database is a complete and continuous process that should start during the database design and development phases and continue during all database-related life cycles in a way that ensures having an up-to-date version of the database documentation that…

SQL Server

Answered Apr 24, 2021 · 1.3K Views Read answer →

Why Are There Constant Dos Attacks On Router Appear To Be Taking Out My Internet Connection? How Do I Prevent It?

SOHO Routers (I've seen this on dlink and netgear at least) are fond of displaying 24hours/mission CRITICAL drama-logs like those. Try installing ddwrt or something similar on that router instead. Then install tcpdump, connect to the router over ssh (putty -log somethingAwry.log 192.168.0.1 (or whatever ip your router…

SQL Server

Answered Apr 23, 2021 · 1.8K Views Read answer →

Where can I find SQLServerManager / SQL Server Configuration Manager?

Try downloading SQL Server year Dev (generally not minimal, Express version). It has a lot of features to choose from, so you are able to install a thing called Client Tools Connectivity which allows you to open SQL Server Configuration Manager. Uses of SQL Server Configuration Manager SQL Server Configuration Manager…

SQL Server

Answered Apr 23, 2021 · 1.5K Views Read answer →

Why WITH CHECK CHECK CONSTRAINT is Used For?

CHECK constraint SQL Server The CHECK constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a column it will allow only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in…

SQL Server

Answered Apr 23, 2021 · 2.1K Views Read answer →

What is the disadvantages to using ON DELETE CASCADE on every foreign key?

Why sql server cascade delete is bad? sql server cascade delete should not cause an unexpected loss of data. If a delete requires related records to be deleted, and the user needs to know that those records are going to go away, then cascading deletes should not be used. Should we use on delete cascade? Yes, the use…

SQL Server

Answered Apr 23, 2021 · 6.7K Views Read answer →

How to Increase speed altering column on a large table to NON-NULL?

Instead of changing the column definition you could add a CHECK CONSTRAINT that doesn't allow NULLs for that column. The table will still need to be scanned but it won't need to modify every single data page, so it should be a much faster operation. Regrettably, an Sch-M lock will still be held during the operation.…

SQL Server

Answered Apr 23, 2021 · 1.6K Views Read answer →