Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server?
Options:-
a) 1
b) 2
c) More...
2014-04-08
589 reads
Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.
Anti-virus are very useful programs from security,...
2014-04-08
13,122 reads
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that...
2014-04-08
403 reads
I’m trying out a new web site from Microsoft called Curah! that is all about curation. Curation is basically what...
2014-04-08
804 reads
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
610 reads
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,787 reads
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....
2014-04-08 (first published: 2014-04-04)
7,109 reads
You still have time to grab the boss and convince him to invest in you. Show what you’ve learned in...
2014-04-08
741 reads
Suppose we need to find out the name of all the months in a given year (Year will be given...
2014-04-08
502 reads
It is April and April Fools has only just begun. Well, or so Matt Velic (blog | twitter) would have us...
2014-04-08
974 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers