VietMX's Blog

Technology Community

Category: ♥ ADO.NET ♥ Android ♥ Angular ♥ AngularJS ♥ ASP.NET ♥ ASP.NET MVC ♥ ASP.NET Web API ♥ C# ♥ CSS ♥ DevOps ♥ Entity Framework ♥ Flutter ♥ Git ♥ Golang ♥ GraphQL ♥ HTML5 ♥ Ionic ♥ Java ♥ JavaScript ♥ jQuery ♥ Kotlin ♥ Laravel ♥ LINQ ♥ MongoDB ♥ .NET Core ♥ NodeJS ♥ OOP ♥ PHP ♥ PWA ♥ Python ♥ React ♥ React Native ♥ Reactive Programming ♥ Redis ♥ Redux ♥ Ruby ♥ Ruby on Rails ♥ Testing ♥ Spring ♥ SQL ♥ T-SQL ♥ TypeScript ♥ UX Design ♥ VueJS ♥ WCF ♥ Web Security ♥ WebSockets ♥ Xamarin ♥ Arrays ♥ Backtracking ♥ Big-O Notation ♥ Binary Tree ♥ Bit Manipulation ♥ Blockchain ♥ Data Structures ♥ Divide & Conquer ♥ Dynamic Programming ♥ Fibonacci Sequence ♥ Graph Theory ♥ Greedy Algorithms ♥ Hash Tables ♥ Heaps and Maps ♥ Linked Lists ♥ Queues ♥ Recursion ♥ Searching ♥ Sorting ♥ Stacks ♥ Strings ♥ Trees ♥ Trie ♥ API Design ♥ Availability & Reliability ♥ Caching ♥ CAP Theorem ♥ Concurrency ♥ Cryptography ♥ Databases ♥ Docker ♥ Layering & Middleware ♥ Load Balancing ♥ Microservices ♥ NoSQL ♥ Reactive Systems ♥ SOA ♥ Software Architecture ♥

Technology Community › Category: T-SQL
Filter:AllOpenResolvedClosedUnanswered
From a T-SQL perspective, how would you prevent T-SQL code from running on a production SQL Server?
ResolvedVietMX asked 5 years ago • 
798 views0 answers0 votes
What are the best practices for using a GUID as a primary key, specifically regarding performance?
ResolvedVietMX asked 5 years ago • 
854 views0 answers0 votes
Is it correct/best practice to have the TRY/CATCH block inside the transaction or should the transaction be inside the TRY block?
ResolvedVietMX asked 5 years ago • 
853 views0 answers0 votes
What is the native system stored procedure to issue a command against all databases?
ResolvedVietMX asked 5 years ago • 
801 views0 answers0 votes
What is the difference between PARTITION BY and GROUP BY
ResolvedVietMX asked 5 years ago • 
819 views0 answers0 votes
What do Clustered and Non clustered index actually mean?
ResolvedVietMX asked 5 years ago • 
769 views0 answers0 votes
Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
ResolvedVietMX asked 5 years ago • 
863 views0 answers0 votes
What is the difference between EXEC vs sp_executesql?
ResolvedVietMX asked 5 years ago • 
802 views0 answers0 votes
What is the use of GO in Transact SQL?
ResolvedVietMX asked 5 years ago • 
825 views0 answers0 votes
Provide an example of Left Outer Join with Exclusions
ResolvedVietMX asked 5 years ago • 
751 views0 answers0 votes
How can you capture the length of a column when it is a Text, NText and/or Image data type?
ResolvedVietMX asked 5 years ago • 
756 views0 answers0 votes
What are bitwise operators and what is the value from a database design perspective?
ResolvedVietMX asked 5 years ago • 
821 views0 answers0 votes
Mention what are ROLLUP and CUBE in T-SQL?
ResolvedVietMX asked 5 years ago • 
768 views0 answers0 votes
What’s the difference between TRUNCATE and DELETE in SQL?
ResolvedVietMX asked 5 years ago • 
790 views0 answers0 votes
What two commands were released in SQL Server 2005 related to comparing data sets from two or more separate SELECT statements?
ResolvedVietMX asked 5 years ago • 
757 views0 answers0 votes
In what version of SQL Server were synonyms released, what do synonyms do and when could you make the case for using them?
ResolvedVietMX asked 5 years ago • 
853 views0 answers0 votes
Mention what is uncommittable transactions?
ResolvedVietMX asked 5 years ago • 
733 views0 answers0 votes
Mention what does the T-SQL command IDENT_CURRENT does?
ResolvedVietMX asked 5 years ago • 
765 views0 answers0 votes
What are the practical differences between COALESCE() and ISNULL(,”)?
ResolvedVietMX asked 5 years ago • 
853 views0 answers0 votes
Is there a difference between T-SQL linked server and a synonym?
ResolvedVietMX asked 5 years ago • 
864 views0 answers0 votes
12

DMCA.com Protection Status