Viewing 15 posts - 181 through 195 (of 216 total)
I found out one of our SQL servers processor information by doing this:
1. use cmd, type systeminfo
I assume that this server is running some version of Windows Server. If...
October 21, 2011 at 1:06 pm
If I detach and reattach will there be old relicks from 2005 ? Will any new 2008 R2 options be lost ?
In either case (backup and restore or detach...
October 21, 2011 at 12:49 pm
GilaMonster (10/21/2011)
October 21, 2011 at 12:43 pm
SQLRNNR (10/17/2011)
Nah - just go with Itziks book. :-D:-D:-D:-D
Do exercise caution, however. If you attempt to read too much of Itzik Ben-Gan in one go, your head may explode.
October 18, 2011 at 2:53 pm
I found a really interesting discussion of the performance differences between inline TVF's and multi-statement TVF's on Stackoverflow.
I'll summarize the discussion here, though.
Bottom line, inline TVF's should be preferred over...
October 9, 2011 at 12:57 pm
Interesting question. I am not completely sure, but I do know that multi-statement TVF's are treated like stored procedures. Like views, inline TVF's are more flexible than stored...
October 9, 2011 at 12:24 pm
Jeff Moden (10/9/2011)
October 9, 2011 at 10:04 am
Jeff Moden (10/9/2011)
October 9, 2011 at 9:43 am
Strangely enough, it doesn't work for me, either! :unsure:
I played around with it for a bit, and got it to work, though. Paste the XML into Notepad (or some...
October 9, 2011 at 9:37 am
Oh! I forgot to test Jeff's query!
SELECT a1, clsdt_date, wrkcpl_date
FROM wt
WHERE ISNULL(DATEDIFF(dd,clsdt_date,wrkcpl_date),0) = 0;
It's hard to say, but it did seem to run...
October 8, 2011 at 11:20 pm
Sure thing, Jeff. I'll try to be really rigorous instead of just kinda rigorous! 😎
To start out, I am going to recreate everything from scratch. Here is the...
October 8, 2011 at 11:09 pm
This is really good stuff! In my particular situation, I am the DBA for the Business Intelligence team at my company. The Application Development group is huge (and...
October 8, 2011 at 6:58 pm
drew.allen (10/6/2011)
You can't do an index seek on cssdt_date until you know the values for wrkcpl_date. You can't...
October 8, 2011 at 6:28 pm
Outstanding! Now, this is the kind of insight that I was after! 🙂
October 8, 2011 at 1:37 pm
sqlfriends (10/8/2011)
Could you update the information on this post after you checked with microsoft?Thanks much
Sure! I'll be at the PASS conference this week. I'll pigeonhole some of the...
October 8, 2011 at 1:35 pm
Viewing 15 posts - 181 through 195 (of 216 total)