Viewing 15 posts - 61 through 75 (of 567 total)
Grant Fritchey (2/3/2014)
wolfkillj (1/29/2014)
February 3, 2014 at 7:48 am
Ed Wagner (1/31/2014)
Luis Cazares (1/30/2014)
Would this help?http://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspx
Maybe even a post from a GUID lover:
http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx
Or even BOL on Using uniqueidentifier Data:
http://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx
I especially like Kimberly's article Luis posted here. Sean, this...
January 31, 2014 at 9:33 am
ChrisM@Work (1/30/2014)
wolfkillj (1/29/2014)
January 30, 2014 at 7:27 am
I created and used my first extended events session last week, and it was great - easy and extremely helpful. I just posted about it on my blog, if you're...
January 29, 2014 at 11:20 am
Sean Lange (1/29/2014)
wolfkillj (1/29/2014)
Sean Lange (1/29/2014)
wolfkillj (1/29/2014)
Ed Wagner (1/29/2014)
Greg Edwards-268690 (1/29/2014)
GilaMonster (1/29/2014)
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
January 29, 2014 at 9:45 am
Sean Lange (1/29/2014)
wolfkillj (1/29/2014)
Ed Wagner (1/29/2014)
Greg Edwards-268690 (1/29/2014)
GilaMonster (1/29/2014)
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
January 29, 2014 at 9:28 am
Ed Wagner (1/29/2014)
Greg Edwards-268690 (1/29/2014)
GilaMonster (1/29/2014)
Ed Wagner (1/29/2014)
GilaMonster (1/29/2014)
Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.
That...
January 29, 2014 at 8:12 am
Jeff Moden (1/25/2014)
January 27, 2014 at 11:33 am
phil.doensen (1/23/2014)
I find
DBCC DROPCLEANBUFFERS
will probably get you back to the 70sec mark,
but to...
January 24, 2014 at 3:40 pm
sturner (1/24/2014)
Its obvious that the event is being sent to the second thread before the transaction (first insert) has committed, regardless of what is going on in your second procedure.
Right...
January 24, 2014 at 2:30 pm
Well, problem identified and solved. I re-ran the XE session to catch the database_transaction_begin and database_transaction_end events. It turns out that even though the insert statements were completing before the...
January 24, 2014 at 1:46 pm
Lynn Pettis (1/24/2014)
Has anyone else ever heard that it is a best practice to have enough server memory to hold your entire database in memory?
That seems to fall into the...
January 24, 2014 at 9:47 am
DataMinder, are you asking for an interface that allows you to do the same thing you do now (find anomalous values, review values from adjacent rows, and execute an update...
January 21, 2014 at 1:56 pm
o.fimin (1/19/2014)
Maybe like this:
with t as(
select 'aaa@xxx.com' EmailAddress, 'ravi' EmployeeName, 5 UNo, 8989898989 MobileNumber
union
select 'bbb@xxx.com', 'ramesh', 7, 9898989898
union
select 'ariv@gmail.com', 'arivu', 13, 8989898989)
select case when Uno=7 then 1 when...
January 21, 2014 at 1:24 pm
Viewing 15 posts - 61 through 75 (of 567 total)