Viewing 15 posts - 3,661 through 3,675 (of 19,560 total)
Thanks for the question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 8:06 am
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 7:40 am
Grant Fritchey (2/17/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 7:33 am
They were probably expiring at the same time because they were created at the same time.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2014 at 7:28 am
Looks like you have no valid means to join the tables (see Jeff's comment).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2014 at 7:04 pm
What is the table definition for each of these tables?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2014 at 6:55 pm
dwain.c (2/16/2014)
DECLARE @sometab TABLE (Person INT, [Date] DATE, [Hours] DECIMAL(12,2))
INSERT INTO @sometab
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2014 at 3:35 pm
Viewing 15 posts - 3,661 through 3,675 (of 19,560 total)