MicSim

less info
meta site favicon meta user | stack exchange network profile network profile
1,024 reputation
513
bio website
location
age
visits member for 1 year, 11 months
seen 2 hours ago
stats profile views 25

67 Actions

suggestions reviews revisions comments badges posts accepts all
Jun
5
 comment Move database files if database runs
You could do a backup and restore that one on the remote machine, if it's just for offline reporting or some consistency checks that you were mentioning. The backup could be done without having any downtime. You'd just have some load on your server.
May
21
 awarded  Constituent
May
14
 awarded  Caucus
Mar
26
 awarded  Organizer
Feb
27
 revised What is the purpose of the USING parameter in SQL?
improved formatting
Jan
18
 comment SQL Server transaction log - shrinking and reattaching
You should not shrink your data file. See for details: sqlskills.com/blogs/paul/…
Sep
12
 revised What is the purpose of the USING parameter in SQL?
reworded
Sep
12
 answered What is the purpose of the USING parameter in SQL?
Sep
8
 accepted Easy way to check connectivity to SQL Server from client
Sep
5
 asked Easy way to check connectivity to SQL Server from client
Jul
16
 answered Poor performance after changing SQL Server 2008 R2 database
Jul
13
 comment MySQL table design / architecture, table is too big
Values in TEXT columns are not stored in the row buffer, but nonetheless get stored in the database at some other memory location (depending on storage engine). Including TEXT fields in your queries might give you performance problems (see: stackoverflow.com/questions/2883867/…)
Jul
12
 awarded  Yearling
Jul
12
 answered MySQL table design / architecture, table is too big
Jul
6
 revised MySQL table with 100,000 records queried often
formatting
Jul
6
 suggested suggested edit on MySQL table with 100,000 records queried often
Jul
5
 accepted Directly acessing the NULL bitmap of a row in SQL Server
Jul
5
 asked Directly acessing the NULL bitmap of a row in SQL Server
Jul
3
 comment What is the actual lowest possible positive REAL number
+1: Haven't heard about subnormal numbers yet.
Jun
29
 revised How to detach a sql server 2008 database that is not in database list?
edited tags
1 2 3 4