Rachel

1,923 reputation

935

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

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,923 reputation	bio	website	rachel53461.wordpress.com	visits	member for	1 year, 3 months
935 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

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,923

votes

answers

kviews

What's the difference between a CTE and a Temp Table?

sql-server cte

1d ago SQLAlan 1

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,923

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

175

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

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

kviews

Are Views optimized when I add a WHERE clause to them?

sql-server sql-server-2005 view query-performance

mar 21 '12 at 19:33 Rachel 1,923

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

votes

answers

844

views

Is it a good idea to use Synonyms to avoid creating a duplicate table?

sql-server database-design

feb 14 '12 at 21:59 ErikE 1,219

votes

answers

482

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

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

answers

195

views

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

sql-server sql-server-2005 failover database-mirroring

may 10 at 13:42 Rachel 1,923

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.3k

votes

answers

263

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.3k

votes

answers

246

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

answer

108

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,923

votes

answer

211

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.8k

votes

answers

979

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.9k

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,913

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,923

votes

answer

kviews

Why does a query run slower in a Stored Procedure than in the Query window?

sql sql-server-2005 stored-procedures query-performance

mar 21 '12 at 15:37 Rachel 1,923

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 1,023

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

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

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

825

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,985

votes

answers

770

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

answer

235

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.9k

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

195

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,665