--Run the following script on Query Analyzer
USE master
--For Data files
EXEC xp_instance_regwrite
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer',
N'DefaultData',
REG_SZ,
N'H:\sql\data'
--For Log files
EXEC xp_instance_regwrite
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer',
N'DefaultLog',
REG_SZ,
N'O:\sql\Log'
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
-
Question: How to Find Table Cardinality from the Execution Plan?
First appeared on How to Find Table Cardinality from the Execution Plan? –
Interview Que...
8 hours ago
No comments:
Post a Comment