Viewing 15 posts - 42,196 through 42,210 (of 49,552 total)
Your screen shot is too compressed to be readable. Please copy the error from the command prompt and paste it in a reply.
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
December 22, 2008 at 12:43 am
30 sec is still a long time for a query to run, unless it's some massive report. I don't know many users who will be happy waiting 30 sec or...
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
December 22, 2008 at 12:29 am
SQL 2000 doesn't have any native encryption functions. If upgrading to 2005 is not an option, you'll have to do the encryption and decryption in the front end app.
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
December 22, 2008 at 12:25 am
That means that the number of columns in the table don't match the number of values in the insert. What's the definition of the Log table?
In general, it it recommended...
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
December 22, 2008 at 12:23 am
Jeff Moden (12/21/2008)
So, what is it, supposedly?
Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database. I'd...
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
December 22, 2008 at 12:22 am
Ahmad Osama (12/21/2008)
however am unable to restore.....
For what reason?
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
December 22, 2008 at 12:07 am
Krishna_DBA (12/21/2008)
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
December 21, 2008 at 8:40 am
Krishna_DBA (12/21/2008)
I have above e books with me if you need any. I can upload them for you.
Those are all copyrighted materials, and hence it is illegal to freely distribute...
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
December 21, 2008 at 8:06 am
RBarryYoung (12/21/2008)
Yes, but Microsoft is the one who started this "Beyond Relational" campaign with SQL Server 2008.
Meaningless marketing drivel. I doubt the people who though that up even...
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
December 21, 2008 at 8:03 am
Not possible without recreating the table completely, which is what Management Studio does.
Why do you need the columns in a specific position? Technically, column order has no meaning in 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
December 21, 2008 at 7:59 am
Krishna_DBA (12/21/2008)
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
December 21, 2008 at 7:53 am
RBarryYoung (12/21/2008)
Or perhaps in the future it will understand "TOP 100%" to mean that we really do want it to sort the data.
Nope. 2000 worked that way, 2005 and 2008...
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
December 21, 2008 at 7:25 am
Domagoj Orec (12/21/2008)
That is right, Master cert is gr8 example
Yeah, but the Master cert is $20,000 and aimed at a very small percentage of IT people. What can be done...
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
December 21, 2008 at 7:19 am
Domagoj Orec (12/21/2008)
as you can take exam if you have some number of years of experience in working on SQL Server, with some proof of that, of course.
How would you...
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
December 21, 2008 at 5:50 am
mahamed_elsirty (12/18/2008)
i upload the exame for u this version is still validstudy this pass4sure good
This site does not permit the posting of links to brain dumps or copyrighted...
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
December 21, 2008 at 2:29 am
Viewing 15 posts - 42,196 through 42,210 (of 49,552 total)