Viewing 15 posts - 6,781 through 6,795 (of 9,399 total)
Jeff Moden (1/3/2015)
http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx
Anyone have even a clue as...
January 3, 2015 at 6:36 pm
Congratulations, Gianluca. Very well done. And no, it didn't sound like you were bragging.
January 3, 2015 at 6:34 pm
crookj (12/30/2014)
Ed Wagner (12/30/2014)
BWFC (12/30/2014)
Ed Wagner (12/30/2014)
TomThomson (12/29/2014)
Ed Wagner (12/29/2014)
eccentricDBA (12/29/2014)
SQLRNNR (12/29/2014)
MandibleIronjaw
Game
Set (and Match)
Tennis
Elbow
Knee
Luv (or love if you wish...)
Zero
December 30, 2014 at 8:30 am
BWFC (12/30/2014)
Ed Wagner (12/30/2014)
TomThomson (12/29/2014)
Ed Wagner (12/29/2014)
eccentricDBA (12/29/2014)
SQLRNNR (12/29/2014)
MandibleIronjaw
Game
Set (and Match)
Tennis
Elbow
Knee
December 30, 2014 at 7:08 am
IncidentalProgrammer (12/29/2014)
December 30, 2014 at 6:00 am
TomThomson (12/29/2014)
Ed Wagner (12/29/2014)
eccentricDBA (12/29/2014)
SQLRNNR (12/29/2014)
MandibleIronjaw
Game
Set (and Match)
Tennis
December 30, 2014 at 5:36 am
So change your ORDER BY clause to suit what order you're after.
ORDER BY r.QUARTILE, CAST(R.Score AS int);
December 29, 2014 at 1:57 pm
eccentricDBA (12/29/2014)
SQLRNNR (12/29/2014)
Ed Wagner (12/29/2014)
djj (12/29/2014)
BWFC (12/29/2014)
Ed Wagner (12/29/2014)
TomThomson (12/28/2014)
djj (12/26/2014)
SQLRNNR (12/26/2014)
DiveFood
Grub
Worm
Wood
Project
Power Tools
Mandible
Ironjaw
Game
December 29, 2014 at 8:09 am
I wish we had a notes column on our electronic timesheets, but we don't, so I use my calendar for keeping track of what I do all day. I...
December 29, 2014 at 6:16 am
Steve Jones - SSC Editor (12/27/2014)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/120079/">Synonyms and Temp Tables</A>
I don't use global temp tables very much myself, but it's good...
December 29, 2014 at 5:51 am
djj (12/29/2014)
BWFC (12/29/2014)
Ed Wagner (12/29/2014)
TomThomson (12/28/2014)
djj (12/26/2014)
SQLRNNR (12/26/2014)
DiveFood
Grub
Worm
Wood
Project
Power Tools
December 29, 2014 at 5:41 am
TomThomson (12/28/2014)
djj (12/26/2014)
SQLRNNR (12/26/2014)
DiveFood
Grub
Worm
December 29, 2014 at 5:27 am
Going back to the OP for a moment, everyone connecting with the sa user is a problem. This means that they can do literally anything on the SQL Server...
December 23, 2014 at 9:27 am
I do it exactly the way Scott described. I switch to the target database, then alter it to single user with rollback immediate. Switch to a different database...
December 23, 2014 at 9:14 am
ramana3327 (12/23/2014)
I am working with database restore. It is showing database is in use. Instead of single_user mode, I use the below query. It is giving error
USE [master]
GO
DECLARE @dbName...
December 23, 2014 at 8:49 am
Viewing 15 posts - 6,781 through 6,795 (of 9,399 total)