Viewing 15 posts - 6,631 through 6,645 (of 22,211 total)
ANn -425914 (2/27/2015)
for indexes, does the order of column matters?
For example I want to create an index of ID, SchoolID, on terms table.
Does the order of...
February 28, 2015 at 12:05 pm
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one hundred bottles...
February 28, 2015 at 12:00 pm
Jeff Moden (2/27/2015)
Grant Fritchey (2/27/2015)
Instead, I'd go with a more standard approach:Heh... why? Portability? 😛
Yes Joe.
February 28, 2015 at 11:59 am
The whole idea around "best practices" is not that they fit in ALL circumstances, but that they fit in MOST circumstances (and most is substantially higher than 50.00001%). Of course...
February 28, 2015 at 11:59 am
sql-lover (2/27/2015)
djj (2/27/2015)
Grant Fritchey (2/27/2015)
February 28, 2015 at 11:53 am
It could be any number of things. The best bet would be to capture wait statistics before and after to understand where the slow down is occurring. That will help...
February 27, 2015 at 1:01 pm
I'm not a fan of GUIDs, but they are not inherently evil. Before you replace it, I'd find out why you have it. If there's no good reason, then by...
February 27, 2015 at 1:00 pm
Personally, the single most important thing here is getting rid of the multi-statement table valued function. Those things are nothing but trouble.
After that, I think everyone else has offered lots...
February 27, 2015 at 12:57 pm
Assuming the Threadizens are aware of this since you're a giant bunch of nerds, but...
Spock is dead.
Leonard Nimoy passed away today.
February 27, 2015 at 10:38 am
Lynn Pettis (2/26/2015)
... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...
Should have said something when I...
February 27, 2015 at 10:37 am
Yeah, a derived table or a Common Table Expression would allow you to do that. Sorry I didn't understand what you were asking.
February 27, 2015 at 8:09 am
There is no way.
Go to your last known good backup.
February 27, 2015 at 6:34 am
You could try doing some of the work in 2014 using In-memory. It still logs things, but not in the same way, at all, especially if you use eventual consistency.
February 27, 2015 at 6:33 am
Replacing just some of the spaces and not other spaces with no precise set of rules means the Mark I eyeball is going to have to be used to do...
February 27, 2015 at 6:31 am
What situation are you seeing this in? I'm unclear as to whether we're inside SQL Server or in an application?
February 27, 2015 at 6:29 am
Viewing 15 posts - 6,631 through 6,645 (of 22,211 total)