SQLRNNR

Forum Replies Created

Viewing 15 posts - 6,256 through 6,270 (of 19,560 total)

RE: Where can i get a sample database for SQL Server 2008 R2?

Steve Jones - SSC Editor (5/18/2012)
Note that if you have the R2 or 2012 versions, they won't attach.
I had no problems attaching either of those two versions (2008 R2 and...
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

May 18, 2012 at 4:02 pm

#1489996
RE: Where can i get a sample database for SQL Server 2008 R2?

You will need to remove the log file from the files to be attached windows.
Highlight the log file and then click remove. The file should say not found. ...
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

May 18, 2012 at 3:52 pm

#1489991
RE: Where can i get a sample database for SQL Server 2008 R2?

what is the error?
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

May 18, 2012 at 3:38 pm

#1489984
RE: Where can i get a sample database for SQL Server 2008 R2?

Once downloaded, then you attach the database file within ssms. Do you know how to attach a database file?
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

May 18, 2012 at 3:16 pm

#1489976
RE: Where can i get a sample database for SQL Server 2008 R2?

Just the data file will work for creating that 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

May 18, 2012 at 2:55 pm

#1489972
RE: Where can i get a sample database for SQL Server 2008 R2?

This should work for you
http://msftdbprodsamples.codeplex.com/releases/view/59211#DownloadId=198008
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

May 18, 2012 at 2:46 pm

#1489969
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/18/2012)
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.
If you are close by, come check us out.
http://bit.ly/JXZNX7
Enjoy! I'll be speaking downtown in Denver tomorrow...
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

May 18, 2012 at 2:12 pm

#1489950
RE: Today's Random Word!

crookj (5/18/2012)
Lynn Pettis (5/18/2012)
Mutt
and Jeff
heff....er
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

May 18, 2012 at 12:56 pm

#1489902
RE: Are the posted questions getting worse?

In Boston now getting ready for SQL Sat 142.
If you are close by, come check us out.
http://bit.ly/JXZNX7
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

May 18, 2012 at 12:52 pm

#1489897
RE: Today's Random Word!

Malamute
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

May 18, 2012 at 11:14 am

#1489851
RE: Are the posted questions getting worse?

party like its -1
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

May 18, 2012 at 11:08 am

#1489846
RE: Foreign key

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

May 18, 2012 at 8:55 am

#1489748
RE: Certification on 2008 or 2012 now?

I agree with Gail on this.
The only reason I would certify on 2008 at this point would be if I am working with 2008 and there are no plans to...
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

May 18, 2012 at 8:28 am

#1489720
RE: Get SSMS 2008 Keyboard mappings?

Have you tried using SSMS 2008 to connect to your 2012 databases? I think that may solve your problem.
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

May 17, 2012 at 8:36 am

#1489063
RE: Re-code to avoid using stored procedures

I am puzzled too as to how not creating a stored proc helps maintain security. Maybe the reason is that they feel it would increase sys admin overhead?
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

May 17, 2012 at 5:45 am

#1488927

Viewing 15 posts - 6,256 through 6,270 (of 19,560 total)