Rachel

1,893 reputation

835

bio	website	rachel53461.wordpress.com
	location	New York, United States
	age	27
visits	member for	1 year, 3 months
	seen	2 days ago
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
835 badges		location	New York, United States		seen	2 days ago

summary answers questions tags badges favorites bounties reputation activity

35 Questions

views newest activity votes

votes

answers

kviews

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

sql-server cte

mar 12 '12 at 8:27 Mel Padden 131

votes

answers

kviews

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

jul 27 at 14:13 Rachel 1,893

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

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

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

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

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

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

kviews

Can I query a tab-delimited file from SSMS?

sql-server-2005 csv-file

dec 4 at 7:29 dartonw 226

votes

answers

930

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

votes

answers

829

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

794

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

748

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

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

465

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

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

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

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

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

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

answer

204

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

vote

answer

199

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

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

183

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

votes

answers

179

views

Can I move a system database from one version of SQL server to another?

sql-server sql-server-2008 sql-server-2005 backup restore

mar 6 '12 at 21:15 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

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

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

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