Viewing 15 posts - 2,386 through 2,400 (of 7,502 total)
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
did you try using Rank() to get your sequence solution ?
, rank() over ( partition by AgentID order by AgentID, RegistrationDatetime asc ) Seq
Depending on the volume of data, this...
January 29, 2011 at 9:23 am
GilaMonster (1/28/2011)
mtillman-921105 (1/28/2011)
'Makes me wonder how easy it would be to do that here in the US or in...
January 29, 2011 at 1:17 am
Viewing 15 posts - 2,386 through 2,400 (of 7,502 total)