Viewing 15 posts - 496 through 510 (of 1,069 total)
Roust_m (7/14/2011)
I only want MCITP SQL 2008 Database Administrator certification. How many exams do I need to pass?
Two.
July 14, 2011 at 11:26 pm
kiran41 (7/14/2011)
I need to write the Exam 70-450.
Kindly send me the study material\dumps for Exam 70-450[PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL...
July 14, 2011 at 11:07 pm
shilpa.shankar87 (7/13/2011)
tcp/ip and named pipes are enabled and firewall option is set to OFF, still im getting same error
Write FQDN.
For example: ServerName.DomainName.com
July 13, 2011 at 5:12 am
thanoseft (7/13/2011)
I have an sql server that is running the transaction log backup every 10 min.
I need to restart this server and in order to do this i will...
July 13, 2011 at 5:10 am
Use SELECT statement. If the column value is NULL, image does not exist.
July 13, 2011 at 3:34 am
I recommend creating two database roles viz. Principal and Staff.
Instead of directly granting the permissions to Users.
June 27, 2011 at 4:53 am
SQL Server does not run on Unix. It runs only on Windows OS.
If you want to be a SQL Server DBA, you need to learn Windows Servers.
June 27, 2011 at 4:48 am
peleg (6/23/2011)
...should i put them on a different disk as well?
Yes, putting the indexes on separate physical disk would improve the performance.
June 27, 2011 at 12:28 am
shilpa.shankar87 (6/22/2011)
i did it but not able to modify the path of the text file..
Text file? Are you talking about Reporting and Logging...
Backup file extensions are .BAK or .TRN
What error...
June 22, 2011 at 3:30 am
shilpa.shankar87 (6/22/2011)
can you please suggest how to modify the existing maintenance plan?
Right click and select Modify.
June 22, 2011 at 2:19 am
My suggestion is to use Maintenance Plan. It creates different backup files with different name. It does not overwrite.
You can add a step to delete older backup files, if you...
June 22, 2011 at 1:43 am
This query is used to set allow page lock on. So I used the condition to select index with allow page locks off currently.
This script is not for index...
June 21, 2011 at 10:33 pm
I have written a script for you. Select the Result to Text and run the query. Copy and paste the output to a new window and run it. This is...
June 20, 2011 at 11:33 pm
Krasavita (6/20/2011)
Hello, I get these error:Column qualifier or table "Tbl1003" undefined
I think you have not specified the column name for expression in your query.
For example:
select name, physical_name, size/128 as 'Size_In_MB'...
June 20, 2011 at 10:38 pm
Viewing 15 posts - 496 through 510 (of 1,069 total)