Viewing 15 posts - 2,386 through 2,400 (of 7,504 total)
Steve Jones - SSC Editor (2/1/2011)
February 2, 2011 at 1:53 am
Gail has published a wonderful article at ssc concerning your Q.
February 1, 2011 at 3:25 pm
I still have the darn pegions 😀
The birds are getting old, way to old to make a good soup:hehe:
February 1, 2011 at 3:22 pm
sqlindia (1/31/2011)
Shall we replace rank() over function with T-SQL (or any other way)?
I mean this line select AgentID,DT,AgentStatus,TeamID
, rank()...
February 1, 2011 at 12:53 am
If you want more info about the failed login itself, you can implement an event notification for failed logins.
(see attachement)
That provides interesting information.
At instance level we have enabled "failed login...
February 1, 2011 at 12:05 am
Grant Fritchey (1/31/2011)
ALZDBA (1/31/2011)
jcrawf02 (1/31/2011)
GilaMonster (1/31/2011)
WayneS (1/31/2011)
So... what's your favorite data modeling tool?Pencil and paper (or marker and whiteboard).
Personally, I prefer using Grant
Oh yes ... Grant has sql plans 😉
Grant...
January 31, 2011 at 1:01 pm
jcrawf02 (1/31/2011)
GilaMonster (1/31/2011)
WayneS (1/31/2011)
So... what's your favorite data modeling tool?Pencil and paper (or marker and whiteboard).
Personally, I prefer using Grant
Oh yes ... Grant has sql plans 😉
Grant has a light...
January 31, 2011 at 12:37 pm
Grant Fritchey (1/31/2011)
January 31, 2011 at 6:29 am
If well planned and prepared, maintenance can be performed at lightning speed 😛
January 31, 2011 at 5:20 am
Your hightlighted part is the actual ranking function.
It will generate a sequenced number (starting from 1) based on AgentID and DT and it will restart numbering from 1 if...
January 31, 2011 at 4:56 am
IMO your ClientInformation_PhoneNumberType table is a lookup table (aka parameter table) where you record a number of characteristics for a certain kind of parameter value.
Typically FK relationships should only be...
January 30, 2011 at 1:46 am
our devs don't import objects into sqlserver.
They write their own little apps to do the trick or use SSIS (very few) to parse, check and load the data.
Especially because tsql...
January 30, 2011 at 12:42 am
the solution is easy, just make sure you're not overloading your db with to much files.
Create a filegroup and add a file to it.
Then create the table specifying that filegroup...
January 30, 2011 at 12:33 am
I'm a database fire fighter, mainly focused on SQLServer.
"They" call / know me whenever they suspect problems with their db/sever.
I help them out and provide guidelines.
I work with my team...
January 29, 2011 at 3:33 pm
so you'd prefer a loop over this:
;with cteAgentSessions
as ( select AgentID,DT,AgentStatus,TeamID
, rank() over ( partition by AgentID order by AgentID, DT asc ) Seq
from @TBL
)
select Logins.AgentID
, Logins.DT...
January 29, 2011 at 3:10 pm
Viewing 15 posts - 2,386 through 2,400 (of 7,504 total)