Viewing 15 posts - 6,631 through 6,645 (of 19,560 total)
Lynn Pettis (3/23/2012)
Also just for some background (or laughs, or horrors depending) our systems administrator is also our DBA and thinks its perfectly 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
March 23, 2012 at 2:37 pm
What OS? 64 Bit or 32?
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
March 23, 2012 at 2:36 pm
The obvious need be asked:
Are you running SQL Server 2008 R2 where you are trying to run that executable?
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
March 23, 2012 at 2:24 pm
Lynn Pettis (3/23/2012)
PaulB-TheOneAndOnly (3/23/2012)
Lynn Pettis (3/23/2012)
GilaMonster (3/23/2012)
sandeep4testing (3/23/2012)
FK- FName should be FK of Users.FNameFK- LName should be FK of Users.LName
Names as foreign keys? That's a weird design.
Even weirder is 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
March 23, 2012 at 1:48 pm
Here is a thread that contains resources that should help.
http://www.sqlservercentral.com/Forums/Topic1232526-391-1.aspx
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
March 23, 2012 at 1:45 pm
Yes this does happen in 2008 but is less common than in 2005. Here is another thread with some great resources on the topic:
http://www.sqlservercentral.com/Forums/Topic1232526-391-1.aspx
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
March 23, 2012 at 1:44 pm
Thanks for getting back with the resolution.
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
March 23, 2012 at 1:37 pm
sandeep4testing (3/23/2012)
Thank u very much for ur quick reply,
i want different primary keys for fname and lname,
here my requirement is :
FK- FName should be FK of Users.FName
FK- LName should...
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
March 23, 2012 at 1:27 pm
GilaMonster (3/23/2012)
Lynn Pettis (3/23/2012)
Wants a primary key on fname and lname.
You say that like it should be obvious it's a bad idea. I got so much flak from a client...
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
March 23, 2012 at 1:13 pm
Peter Maloof (3/23/2012)
Gianluca Sartori (3/23/2012)
It was impossible to have search results without porn sites within.
It was only a matter of time before those rules reappeared...
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
March 23, 2012 at 11:12 am
What error are you getting?
What has made you determine that the file you downloaded is not the 2008 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
March 23, 2012 at 11:08 am
I think to answer that question largely depends on you. Do you prefer to have live instruction with direct easy access? Or do you prefer the method 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
March 23, 2012 at 11:00 am
Another option (I use this one) is by Michelle Ufford, here[/url].
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
March 23, 2012 at 10:38 am
Gianluca Sartori (3/23/2012)
Here's an interesting link on the topic:
My preferred search engine back in the day was Altavista. It seemed to provide more reliable results - especially for tech...
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
March 23, 2012 at 10:22 am
This download works perfectly fine for me
http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=106391
This is the database files for SQL 2008.
How are you determining that the download you used is not the 2008 files?
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
March 23, 2012 at 10:19 am
Viewing 15 posts - 6,631 through 6,645 (of 19,560 total)