Rachel

1,893 reputation

735

bio	website	rachel53461.wordpress.com
	location	New York, United States
	age	27
visits	member for	1 year, 3 months
	seen	yesterday
stats	profile views	366

I'm a programmer, not a DBA! Tell them to stop making me figure out and perform the job of a DBA, and I'll stop harassing your site with questions :)

	1,893 reputation	bio	website	rachel53461.wordpress.com	visits	member for	1 year, 3 months
735 badges		location	New York, United States		seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

35 Questions

views newest activity votes

votes

answers

182

views

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

may 10 at 13:42 Rachel 1,893

votes

answers

views

How can I search the full text of a stored procedure for a value?

sql-server sql-server-2005 stored-procedures information-schema

may 8 at 15:00 RoKa 993

votes

answers

views

How can I query data from a linked server, and pass it parameters to filter by?

sql-server sql-server-2005 query-performance linked-server

may 7 at 13:06 Rachel 1,893

votes

answers

views

Can I copy the table structure of a #temp table to a new physical table?

sql-server sql-server-2005 temp-tables

apr 23 at 15:44 Rachel 1,893

votes

answer

views

Can I shrink the transaction log file on a mirror database?

sql-server transaction-log database-mirroring

apr 22 at 14:46 Thomas Stringer 14.2k

votes

answer

views

How do I shrink the physical Transaction Log file when it's the principal in a mirror?

sql-server sql-server-2005 backup transaction-log mirroring

apr 22 at 13:19 Rachel 1,893

votes

answers

262

views

Is there any difference between putting a column alias at the start or the end of the column definition?

sql-server sql t-sql best-practices

feb 26 at 16:52 Thomas Stringer 14.2k

votes

answers

kviews

How can I call a remote User Defined Function with Parameters?

sql-server-2005

feb 24 at 18:46 Rogue 1

votes

answers

462

views

Can I launch a stored procedure and immediately return without waiting for it to finish?

sql-server sql-server-2005 stored-procedures

feb 18 at 21:22 paco 41

votes

answer

157

views

Deciding between an IsDeleted/DateDeleted column or a separate History table?

sql-server database-design

feb 6 at 14:45 Jim 51

votes

answer

203

views

How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?

sql-server sql-server-2005 maintenance database-backup

jan 25 at 21:40 Mark Storey-Smith 18.7k

votes

answers

135

views

Can I manually reset the “internal status flag for a full database backup”?

sql-server-2005 database-backup

jan 21 at 18:52 mrdenny♦ 17.1k

votes

answers

115

views

Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?

sql-server-2005 backup database-backup

jan 14 at 21:09 Ali Razeghi 1,907

votes

answers

923

views

How can I backup a large SQL Server database without impacting performance?

sql-server sql-server-2005 backup

dec 18 at 19:21 Aaron Bertrand 35.4k

vote

answer

197

views

How can I stop SQL from validating an OPENROWSET query when its not going to be executed?

sql-server sql-server-2005 openrowset

dec 6 at 15:35 Kevin Feasel 1,884

votes

answer

kviews

Can I query a tab-delimited file from SSMS?

sql-server-2005 csv-file

dec 4 at 7:29 dartonw 226

votes

answers

793

views

How can I get the correct offset between UTC and local times for a date that is before or after DST?

sql-server sql-server-2005 utc-time timezone

dec 1 at 5:22 Paul White 7,865

votes

answers

746

views

Is there a more concise way to convert a UTC datetime into a local date only?

sql-server sql-server-2005 query-refactor

oct 22 at 14:10 Max Vernon 4,196

votes

answers

170

views

Is there way to join every row of TableA to a row of the smaller TableB by repeating TableB however many times are needed?

sql-server-2005 query-refactor

oct 19 at 17:52 Max Vernon 4,196

votes

answer

233

views

Why does using a Real data type in a mathematical equation return an incorrect result?

sql-server sql-server-2005 datatypes

sep 13 at 14:27 Aaron Bertrand 35.4k

votes

answers

610

views

What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?

sql-server-2005 performance stored-procedures entity-framework

aug 22 at 21:52 Delux 124

votes

answers

kviews

What is the most efficient way to get the minimum of multiple columns on SQL Server 2005?

sql-server sql-server-2005 performance aggregate

jul 27 at 14:13 Rachel 1,893

votes

answer

kviews

How can I strip non-numeric characters out of a string?

sql-server sql-server-2005 t-sql

jul 19 at 16:39 Jon Seigel 6,863

votes

answer

409

views

Is there a way to setup a user to run SPs, but not access the underlying data tables?

sql-server-2005 permissions linked-server

jun 18 '12 at 19:42 Rachel 1,893

votes

answers

173

views

Which of these table designs is better for performance?

sql-server performance database-design

jun 12 '12 at 0:30 Uğur Gümüşhan 159

votes

answers

186

views

Is there any significant difference between Month(date) and DatePart(month, date)?

sql-server sql-server-2005

may 16 '12 at 13:16 JNK♦ 8,565

votes

answers

kviews

Why do people recommend not using the name “Id” for an identity column?

identity naming-convention

apr 18 '12 at 17:13 Rachel 1,893

votes

answers

244

views

How can I identify when to create a new table to hold data that can be obtained from a query?

sql-server sql-server-2005 query-performance

apr 2 '12 at 18:04 Jan Steinman 141

votes

answers

336

views

Is it more secure to go through a 3rd database to connect two databases using the same login?

database-design security

mar 27 '12 at 4:35 Community♦ 1

votes

answers

kviews

Why is an aggregate query significantly faster with a GROUP BY clause than without one?

sql sql-server-2005 query-performance aggregate parallelism

mar 22 '12 at 2:47 yo hal 149