Viewing 15 posts - 3,661 through 3,675 (of 19,564 total)
Koen Verbeeck (2/17/2014)
Cody K (2/17/2014)
Michael Earl-395764 (11/18/2008)
Is it me, or are the posted questions getting worse these days?
It's not just you.
People can't research to avoid their problems in the first...
February 17, 2014 at 7:40 am
Grant Fritchey (2/17/2014)
February 17, 2014 at 7:34 am
BWFC (2/17/2014)
Ed Wagner (2/14/2014)
SQLRNNR (2/14/2014)
Revenant (2/14/2014)
TomThomson (2/14/2014)
JAZZ Master (2/14/2014)
crookj (2/14/2014)
SQLRNNR (2/14/2014)
breakfastMissed
Avoided
Evaded
Sneak
Attack
Destroy
Seek
Hide or
February 17, 2014 at 7:33 am
They were probably expiring at the same time because they were created at the same time.
February 17, 2014 at 7:28 am
Looks like you have no valid means to join the tables (see Jeff's comment).
February 16, 2014 at 8:11 pm
dwain.c (2/16/2014)
zulfansari (2/16/2014)
Thank you VERY MUCH for the quick solution, I will test this as soon as I get back in the office on Monday..
OK I'll bite. What's a...
February 16, 2014 at 7:16 pm
There are a few ways to do that.
1 would be a server logon trigger.
Another (better imho) method is to use an AD account. Then place login restrictions at the...
February 16, 2014 at 7:04 pm
dwain.c (2/16/2014)
DECLARE @sometab TABLE (Person INT, [Date] DATE, [Hours] DECIMAL(12,2))
INSERT INTO @sometab
...
February 16, 2014 at 6:48 pm
Jeff Moden (2/16/2014)
I believe that a part of your problem is that you've hardcoded the database ID in your code at the following line.
from sys.dm_db_index_physical_stats ([font="Arial Black"]5[/font], null,null,null,'Limited') S
Yeah, that...
February 16, 2014 at 6:43 pm
vanessa4biz (2/16/2014)
I am trying to defrag indexes on user databases. I don't believe heap tables have indexes.
Heap tables can have indexes. Heaps can become fragmented too and should be...
February 16, 2014 at 6:42 pm
you are joining to sys.indexes which will cause the results to only be returned for the current execution database.
You will need to run the same thing against each database. ...
February 16, 2014 at 1:55 pm
Do you have sample data and table structures for us to use? This will significantly improve your chances of getting a viable answer.
February 16, 2014 at 1:47 pm
Koen Verbeeck (2/15/2014)
HappyHallmarkValentine's Day!
I think you had it right before the strike through.:-D
February 15, 2014 at 3:35 pm
Viewing 15 posts - 3,661 through 3,675 (of 19,564 total)