Forum Replies Created
Viewing 15 posts - 2,401 through 2,415 (of 19,560 total)
-
RE: Creating Index take a long time
WhiteLotus (8/3/2014)
SQLRNNR (8/3/2014)
Did you check the status of the index creation while in progress? Did you check for blocking?Does the dev server have just a small amount of RAM...
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 -
RE: Creating Index take a long time
WhiteLotus (8/3/2014)
SQLRNNR (8/3/2014)
Did you check the status of the index creation while in progress? Did you check for blocking?Does the dev server have just a small amount of RAM...
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 -
RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?
george sibbald (8/3/2014)
me too, but who's complaining? 🙂Me!! Take my points back. I protest!! :-D:hehe:;-)
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 -
RE: Creating Index take a long time
Did you check the status of the index creation while in progress? Did you check for blocking?
Does the dev server have just a small amount of RAM or little...
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 -
RE: DBA vs Developer
Eirikur Eiriksson (8/3/2014)
Jeff Moden (8/3/2014)
TomThomson (8/3/2014)
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.Heh... what's...
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 -
RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?
Really surprised by the point value of this question.
Good fundamental 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 -
RE: Quickcert
Can't say that they are or that they are not a braindump.
Based on the website and name, it appears to be designed around the bootcamp model. That would tell...
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 -
RE: Resume font ?
Eirikur Eiriksson (8/3/2014)
If the appearance of the resume adds a value to it then selecting a font isn't enough. One should properly layout the document using the likes of Scribus,...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 -
RE: indexing a table having million of records
raj.prabhu001 (8/3/2014)
Hello,I have a fact table which has six field now and I have created non clustered index on all fields.
It will also have more fields later with millions of...
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 -
RE: Query source for Missing Index Management Views
Here is a query to shred the plan cache for missing indexes.
I am a little more partial to this one. There are updates for it in the works too.
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 -
RE: Today's Random Word!
TomThomson (8/2/2014)
Ed Wagner (8/1/2014)
BoatSauce
Submarine
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 -
RE: Restore of db fails
When checkdb completes without error, then I'd say you have plenty of proof to show them that the storage is not ok.
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 -
RE: backup and restore users and logins
You can use sp_help_revlogin to help transfer logins.
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 -
RE: Today's Random Word!
Ed Wagner (8/1/2014)
SQLRNNR (8/1/2014)
batgirl (8/1/2014)
SQLRNNR (8/1/2014)
Ed Wagner (8/1/2014)
Fettuccinebroccoli
bocci
balloon
Bloat
Barge Pole
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 -
RE: handle resultset in SP
What is it that you don't understand yet?
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
Viewing 15 posts - 2,401 through 2,415 (of 19,560 total)