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 • 
808 views0 answers0 votes
What are the best practices for using a GUID as a primary key, specifically regarding performance?
ResolvedVietMX asked 5 years ago • 
864 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 • 
864 views0 answers0 votes
What is the native system stored procedure to issue a command against all databases?
ResolvedVietMX asked 5 years ago • 
814 views0 answers0 votes
What is the difference between PARTITION BY and GROUP BY
ResolvedVietMX asked 5 years ago • 
830 views0 answers0 votes
What do Clustered and Non clustered index actually mean?
ResolvedVietMX asked 5 years ago • 
780 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 • 
871 views0 answers0 votes
What is the difference between EXEC vs sp_executesql?
ResolvedVietMX asked 5 years ago • 
809 views0 answers0 votes
What is the use of GO in Transact SQL?
ResolvedVietMX asked 5 years ago • 
833 views0 answers0 votes
Provide an example of Left Outer Join with Exclusions
ResolvedVietMX asked 5 years ago • 
758 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 • 
769 views0 answers0 votes
What are bitwise operators and what is the value from a database design perspective?
ResolvedVietMX asked 5 years ago • 
831 views0 answers0 votes
Mention what are ROLLUP and CUBE in T-SQL?
ResolvedVietMX asked 5 years ago • 
778 views0 answers0 votes
What’s the difference between TRUNCATE and DELETE in SQL?
ResolvedVietMX asked 5 years ago • 
799 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 • 
763 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 • 
865 views0 answers0 votes
Mention what is uncommittable transactions?
ResolvedVietMX asked 5 years ago • 
744 views0 answers0 votes
Mention what does the T-SQL command IDENT_CURRENT does?
ResolvedVietMX asked 5 years ago • 
772 views0 answers0 votes
What are the practical differences between COALESCE() and ISNULL(,”)?
ResolvedVietMX asked 5 years ago • 
866 views0 answers0 votes
Is there a difference between T-SQL linked server and a synonym?
ResolvedVietMX asked 5 years ago • 
876 views0 answers0 votes
12

DMCA.com Protection Status