180 reputation
16
bio website
location
age
visits member for 2 years, 11 months
seen Aug 5 at 3:11

Sep
5
awarded  Notable Question
Mar
31
awarded  Popular Question
Mar
8
comment Does large table variables fill up logs in tempdb?
@MartinSmith Thanks for a great response. With tempdb in simple recovery should the log space be released after the transaction has been complete? DBA said it was not release in case of Table Variable.
Mar
8
accepted Does large table variables fill up logs in tempdb?
Mar
8
asked Does large table variables fill up logs in tempdb?
Mar
20
awarded  Nice Question
Jan
3
comment Insert bulk Parent and Children rows using SQL Query
Is there a reason why you want to do it using a single query? You can use multiple queries within a SQL transaction to attain atomicity.
Jan
3
comment What is a good way to verify that a restore completed successfully in SQL Server?
Along with what Martin said, you can run RESTORE VERIFYONLY to see if you bak file is in a consistent state.
Dec
29
comment First time running a replication on SQL Server 2008. “The process could not connect to subscriber 'SERVER2'”
Does the service account that your publisher is running under have proper permission on all your subscriber servers?
Dec
27
answered How to design this simple DB?
Dec
27
answered How to dive into an ugly database?
Dec
27
comment How to make a transition from SQL Server DBA to Oracle?
Wow this is very close to what I was looking for. Great information! I read that Oracle has SQL server type jobs that can be ran automated. Anything equivalent to SSIS in Oracle?
Dec
27
awarded  Supporter
Dec
27
awarded  Scholar
Dec
27
accepted How to make a transition from SQL Server DBA to Oracle?
Dec
27
awarded  Student
Dec
27
asked How to make a transition from SQL Server DBA to Oracle?
Dec
22
awarded  Teacher
Dec
21
answered How to restore SQL Server database just by dbName and physical path