Viewing 15 posts - 40,981 through 40,995 (of 49,552 total)
Roy Ernest (2/18/2009)
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
February 18, 2009 at 2:05 pm
Steve Jones - Editor (2/18/2009)
What features would really help you "high posters" here at SSC? Changes to the forums? the site?
Can you ask for one small change please. Remove 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
February 18, 2009 at 2:00 pm
Grant Fritchey (2/18/2009)
Ramesh (2/18/2009)
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
February 18, 2009 at 1:56 pm
Ramesh (2/18/2009)
Using "sa" LoginUsing Administrator login
Or you can just run the SQLProv.exe tool that's provided with SP2 to set the desired administrative logins for you.
Do a file search to find...
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
February 18, 2009 at 1:53 pm
Post the execution plan please (saved as a .sqlplan file, zipped and attached)
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
February 18, 2009 at 1:11 pm
winston Smith (2/18/2009)
Msg 5120, Level 16, State 101, Line 2Unable to open the physical file "C:\DatabaseRestoreTest\Files_location\test_DB_temp.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)".
Google tells...
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
February 18, 2009 at 1:11 pm
Were there any messages in the error log concerning the restore?
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
February 18, 2009 at 8:57 am
lior (2/18/2009)
When I run a backup from Management Studio everything go smooth.The error message apears only when the application that is using the database tries to execute a backup.
So what'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
February 18, 2009 at 7:07 am
prakash414 (2/18/2009)
i am getting error after when i am executing this script
I saw that. I'm asking what the sql statement looks like before it's executed. Use PRINT to see 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
February 18, 2009 at 7:03 am
swmsan (2/17/2009)
Can anyone send me some interview questions pls.
Different companies will ask different questions. Memorising sample questions is unlikely to help.
Advice:
Relax
Don't exaggerate your abilities.
If you don't know...
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
February 18, 2009 at 5:56 am
Are you aware that ALTER DATABASE .. MODIFY FILE does not actually move the files? It just changes the metadata for the database saying where the files are. Once...
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
February 18, 2009 at 5:22 am
Print the sql string before you execute it and check it for any errors.
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
February 18, 2009 at 5:19 am
Run profiler (or preferably a server-side trace) for an hour or so during the server's busy time. Find the 3 or so queries that are running the longest or using...
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
February 18, 2009 at 5:08 am
As the error says, the view or function is not updatable because the update command you've issued affects more than one table. An update can only affect a single table.
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
February 18, 2009 at 5:02 am
nicholas.catley (2/18/2009)
I'm afraid that it wasn't!
It's usually a good idea when criticising someone else's spelling or grammar to ensure that you make no such mistakes in your criticism. 😉
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
February 18, 2009 at 5:01 am
Viewing 15 posts - 40,981 through 40,995 (of 49,552 total)