Viewing 15 posts - 31 through 45 (of 374 total)
Revenant (8/5/2014)
Hany Helmy (8/5/2014)
Thanx 4 the easy 2 pts.+1
+1
August 5, 2014 at 11:47 pm
Nice one.
When I observed this feature, I was happy 🙂
August 5, 2014 at 10:55 pm
GilaMonster (8/5/2014)
What's 73-461? The beta exam?
73 series comes under Microsoft IT Academy. There is no difference between 70 series and 73 series exam Curriculum.
August 5, 2014 at 7:56 am
Thomas Abraham (8/1/2014)
Thanks for question! Easy but still had to think about it. Please post another QOTD.
Sure, on the way 😛
August 1, 2014 at 7:41 am
You also need to check Application code. It may have some ad-hoc queries that is executing stored procedures or using tables.
What about database objects used in Functions (table value...
August 1, 2014 at 7:35 am
Once you take the backup, please verify the backup using "RESTORE VERIFYONLY" command.
Recently my friend faced an issue - after coping the 8 GB backup file from network drive, he...
July 31, 2014 at 3:07 am
Stewart "Arturius" Campbell (7/31/2014)
SQLRNNR (7/30/2014)
Good Question.I do think the answer is a dead give away if you have familiarity with sys.objects though.
+1
Nice one, thanks Shiva
+1
July 31, 2014 at 2:47 am
pchirags (6/23/2014)
nice and easy one..thanks andy.
+1
July 28, 2014 at 6:54 am
What kind of data are you storing in your MDF file? It may possible that fragmentation playing role here.
refer: http://msdn.microsoft.com/en-IN/library/ms188917.aspx
July 28, 2014 at 5:54 am
Author should mention the SQL Server version. Agree with all
July 28, 2014 at 5:17 am
SqlMel (7/27/2014)
GilaMonster (7/25/2014)
robert.diley (7/25/2014)
Then I looked at the query plan for the example in the TechNet article at http://technet.microsoft.com/en-us/library/ms187638(v=sql.105).aspx. What it shows (at least...
July 28, 2014 at 5:10 am
Jamsheer (7/21/2014)
SQLRNNR (7/21/2014)
Very good question - imho.+1 🙂
+1
July 25, 2014 at 1:10 am
Luis Cazares (7/22/2014)
Are you measuring the time to retrieve the 4 million rows? or are you including the time to show them?What are you expecting to get?
+1
What should be...
July 22, 2014 at 11:42 pm
abhas (7/22/2014)
Thank you anthony and Hardy.Thank you very much for both of you for quick reply.
Both approaches are working fine.
Thanks
Abhas.
Great, good to know 😛
July 22, 2014 at 10:27 pm
Viewing 15 posts - 31 through 45 (of 374 total)