Viewing 15 posts - 10,441 through 10,455 (of 49,566 total)
Please note: 4 year old thread (bumped by a spam post)
January 12, 2014 at 11:11 am
Use three-part naming for your queries
SELECT <column list> FROM Sims.dbo.Students
SELECT <column list> FROM SimsCopy.dbo.Students
January 12, 2014 at 8:35 am
01/10/2014 19:27:42,spid121,Unknown,A read of the file 'F:\Database\MyDB1\MyDB1MyDB1.mdf' at offset 0x000003b0670000 succeeded after failing 1 time(s) with error: 1117(The request could not be performed because of an I/O device error.). Additional...
January 12, 2014 at 8:32 am
When you move databases from one place to another (any database), you have to move the files, SQL doesn't automatically move files around for you.
Looks like you may want to...
January 12, 2014 at 4:10 am
Nothing to do with the deadlock, unlikely to be permissions.
What does the SQL error log say? Post all messages from those 20 minutes.
January 11, 2014 at 8:14 am
homebrew01 (1/10/2014)
I am wondering if there is a performance difference if the WHERE MemberType = 'SPECIAL' is in the view, or outside in the code that uses the view:
No.
January 10, 2014 at 2:45 pm
homebrew01 (1/10/2014)
GilaMonster (1/10/2014)
January 10, 2014 at 2:44 pm
Meltdown (1/10/2014)
I was just curious if there was a ON/OFF switch for UNION queries.
No.
But again, the problem is not union. The problem is SQL injection. If the code is not...
January 10, 2014 at 1:04 pm
You'll see heavier usage on TempDB, but it may not be significant depending on your workload.
January 10, 2014 at 12:49 pm
Meltdown (1/10/2014)
Here's a few sql-injection examples being fired at the database - first three using UNION ALL.
The vulnerability there is not the union, it's the SQL injection. Prohibit union and...
January 10, 2014 at 12:36 pm
Lynn Pettis (1/10/2014)
January 10, 2014 at 12:25 pm
No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and so adding...
January 10, 2014 at 10:19 am
No, because they're not executed.
January 10, 2014 at 8:06 am
Jeff Moden (1/10/2014)
I believe Gail refers to such "best practices" as "howlers". 🙂
Not me. 'Howlers' was the title for a series of Simple-Talk articles.
January 10, 2014 at 7:32 am
sqlredcedar (1/10/2014)
We were brainstorming with a solution to apply Transaction Log Backups to create CDC entries on a secondary database.
That won't work. CDC uses the transaction log, reading the...
January 10, 2014 at 7:21 am
Viewing 15 posts - 10,441 through 10,455 (of 49,566 total)