2013-04-03 (first published: 2013-03-08)
1,674 reads
Vinay Kumar
- Interests: Hi, I worked with different technologies like C#, ASP.NET, Web services and sql server. But i was fall in love with sql server and became a DBA. I always try to learn something new or recall old stuff. Frankly speaking, i don't think that i am a DBA. Still learning. I like to spend my spare time with my family and friends. Recently, i have stared blogging and improving my writing way. :-). that's all about me. Keep Learning - Keep Growing !!! Thanks Vinay Kumar
2013-04-01 (first published: 2013-03-08)
1,776 reads
2013-03-29 (first published: 2013-03-08)
1,399 reads
2013-02-18 (first published: 2013-01-25)
2,747 reads
2012-08-13 (first published: 2012-07-31)
1,777 reads
2011-11-18 (first published: 2008-01-29)
2,888 reads
Copy Multiple objects from One Schema to Another Schema
Copy Multiple objects from One Schema to Another Schema
2011-09-30 (first published: 2011-09-07)
1,526 reads
2011-08-31 (first published: 2011-08-24)
2,483 reads
Create Database User
This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.
2011-05-11 (first published: 2011-04-28)
1,779 reads
2011-04-26 (first published: 2011-04-20)
2,653 reads
Blogs
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
Forums
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Duplicate Documents
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers