meta user
network profile
| bio | website | avakharia.com |
|---|---|---|
| location | ||
| age | 29 | |
| visits | member for | 4 months |
| seen | May 17 at 21:00 | |
| stats | profile views | 3 |
A curious web developer, junior DBA and an ethical hacker.
|
May 17 |
comment |
Copy tables from a stand-by database Just use management studio's import/export wizard and it will take care of creating the tables and importing data. You might want to disable referential integrity constraints if any. |
|
May 17 |
comment |
Installation of SQL Server RAID 10 vs RAID 5 I agree with Aaron. We moved from RAID5 to RAID10 a year or so ago and have seen dramatic improvements in writes as well as reads. |
|
May 16 |
comment |
Total Memory used by SQL Server (64 bit) That's true. How about using 'dbcc memorystatus' and parsing the data using Powershell - blogs.msdn.com/b/timchapman/archive/2012/08/16/… |
|
May 10 |
comment |
Total Memory used by SQL Server (64 bit) I use this to track physical memory for my databases. ------------------------------------------------------------------------- SELECT total_physical_memory_kb, available_physical_memory_kb, total_page_file_kb, available_page_file_kb, system_memory_state_desc FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE); |
|
May 10 |
comment |
How to check if database is in mirrored mode? What difference does it make if I query sys.databases or sys.database_mirroring? |
|
Mar 29 |
revised |
sql server-percentage calculation added 1218 characters in body |
|
Mar 21 |
answered | sql server-percentage calculation |
|
Mar 20 |
awarded | Informed |
|
Mar 19 |
answered | How to check if database is in mirrored mode? |
|
Mar 19 |
answered | In what data type should I store an email address in database? |
|
Jan 30 |
answered | SQL Server Database Synchronization |
|
Jan 30 |
awarded | Commentator |
|
Jan 30 |
comment |
SQL update satement taking a very long time / high disk usage for hours It looks like the index/data on that ID is corrupted. This link might be helpful in figuring it out: simple-talk.com/sql/database-administration/… |
|
Jan 20 |
answered | Restore a Database to a New database (T-SQL) |
|
Jan 18 |
awarded | Scholar |
|
Jan 18 |
comment |
Read only/Standby database - Set user permissions Thanks guys for the tip. It helped and it works now. |
|
Jan 18 |
accepted | Read only/Standby database - Set user permissions |
|
Jan 17 |
comment |
Read only/Standby database - Set user permissions I'll try the SID method tonight and let you know how it goes. |
|
Jan 17 |
comment |
Read only/Standby database - Set user permissions It's a SQL login. |
|
Jan 17 |
awarded | Editor |
