|
Browse by Tags
All Tags » QOD
Sorry, but there are no more tags available to filter with.
-
How can you see the last restore (NOT backup) date of your database ?
(At this kind of question in a day I answer in other day you answer, today is a
day when you can answer)
-
Let's say you uncheck the "User must change password at next login" (see QOD 2006-10-09 at http://sqlserver.ro/forums/thread/283.aspx )
and click on "OK" button. After following situation follow an error. Why and what should you do for that?
-
Click on OK button and you will have an error. Why?(At this kind of question in a day I answer in other day you answer, today is a day when you'll answer)
-
On which SQL Server 2005 editions can you use database snapshots ?
Place the mouse cursor HERE for the answer
Reference: http://msdn2.microsoft.com/en-us/library/ms175158.aspx
-
You want to install SQL Server 2005 Standard Edition on a machine that has the following configuration:
CPU: Pentium III 600 Mhz
Memory: 256 MB
HDD: 80 GB (60GB free space).
You have to establish if this configuration satisifies the minimum hardware requirements and if not what component should be upgraded.
Place the mouse cursor HERE for the ...
-
You want to create a stored procedure that will access a remote SQL Server named TestSrv.You add the TestSrv as a linked server using the following code:USE master;
GO
EXEC sp_addlinkedserver
'TestSrv',
N'SQL Server'
GO
You want to select data using the local stored procedure from the Sales.SalesOrderDetails table located in the ...
-
What statement allows you to rebuild, reorganize, disable or enable an index in SQL Server 2005 ?
Place the mouse cursor HERE for the answer
Reference: http://msdn2.microsoft.com/en-us/library/ms188388.aspx
-
What statements allow you to manage statistics in SQL Server 2005 ?
Place the mouse cursor HERE for the answer
Reference: ''Statistics Used by the Query Optimizer in Microsoft SQL Server 2005'' http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
-
Which T-SQL predicate allows you to search columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases?
Place the mouse cursor HERE for the answer
|
|
|