Viewing 15 posts - 33,046 through 33,060 (of 49,552 total)
Highly unlikely to be useful. There are edge-cases where it can be, but very rare. SQL will use the NC if it thinks it'll be faster, but is rare unless...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 8:53 am
Bhuvnesh (5/6/2010)
TheSQLGuru (5/6/2010)
That type of WHERE clause is HORRIBLE from a performance standpoint. Our own Gail Shaw has a very nice...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 8:48 am
You could download the entire of SQL Evaluation version, it'll probably be in there. It's not a separate download afaik.
Why are you installing BIDs on a server in the first...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 8:16 am
mckinnj1 (5/6/2010)
As previously re-explained, I restored the the BAK to a new db without the updated ldf file. This created a new ldf file.
So a normal database restore. The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 8:15 am
It shouldn't take days configured correctly. I've copied much bigger than that in hours. DTS, SSIS or BCP are your options here. The 2008 backup cannot be restored to SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 8:11 am
Install it off the SQL Server DVD. It is included in Standard edition (but not workgroup, web or express).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 7:55 am
What you're trying cannot be done. There is no way to take a database on a higher version and put it onto a lower version. Both backup/restore and detach/attach will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 7:51 am
mckinnj1 (5/6/2010)
homebrew01 (5/5/2010)
The OP seems to be posting hastily without taking the time to properly explain the problem or the attempted solutions. If it's important, perhaps he/she will try harder.
Wow....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 7:40 am
mckinnj1 (5/6/2010)
Lynn Pettis (5/5/2010)
Were you able to restore the database itself as under a differnet name using the .bak...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 7:38 am
sqlwars (5/6/2010)
Its still DBA and from where I am right now, I dont see fun there.
So what do you consider fun? What interests you, what do you want to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 7:04 am
Don't try and write the certs if you have no experience. Get the study guide if you must (they're not all bad, but they're not all good), download the eval...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 6:57 am
Henrico Bekker (5/6/2010)
Next on your agenda I would say is to go for MVP status.
Um.....
MVP status is not something that you should be 'going for' as a career goal. It's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 6:54 am
elchuru (5/6/2010)
extension of second questionWhat type problems i will get after deletion of those two databases?
Reporting services will not work, all your reports will have been lost, schedules, permissions,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 6:50 am
Grant Fritchey (5/6/2010)
Gianluca Sartori (5/6/2010)
Dave Ballantyne (5/6/2010)
Anyone fancy mind-dumping there entire sql knowledge into a few threads :rolleyes:http://www.sqlservercentral.com/Forums/Topic916801-1292-1.aspx
http://www.sqlservercentral.com/Forums/Topic916751-1292-1.aspx
I could try to attach my whole SQL knowledge to that thread, it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 6:45 am
diva.mayas (5/6/2010)
# what is critical, is the allowable data loss in the case of a disaster ?its 0% data loss in case of disaster
Not possible just using backups. For...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2010 at 6:40 am
Viewing 15 posts - 33,046 through 33,060 (of 49,552 total)