Viewing 15 posts - 28,216 through 28,230 (of 39,804 total)
Users don't log into a database. They log into a server (SQL Server instance) and access a database. As Brian mentioned, only tracking every query would tell you when they've...
June 16, 2008 at 11:06 am
In ASCII text, Windows systems, we often have carriage return (CR) and a line feed (LF). Unix can be different.
Look up ASCII codes and experiment. CHR(13) should work, but Excel...
June 16, 2008 at 11:05 am
Go with Itzak's book.
Grant is a little shy, but I'd recommend his execution plans book as well. Available as a promotion from Red Gate software in our newsletter and on...
June 16, 2008 at 11:04 am
Use charindex/patindex to find the place where the occurs and then SUBSTRING to extract around it.
June 16, 2008 at 11:03 am
Ah, interesting. Which culture?
Promotional here means advertising or announcing.
I can't think of one, but I'm sure that there would be something funny to use in the US. Maybe Pseudo-DBA
June 16, 2008 at 11:02 am
This is a cross tab. Search for that and you'll see lots of solutions.
June 16, 2008 at 10:47 am
I haven't seen this. Is there anything strange about the account? I'd run profiler and see what's using this account, what it's doing. that might help clue things in.
June 16, 2008 at 10:46 am
So, time%60 should work, correct?
June 16, 2008 at 10:45 am
8 disks is a lot, and I'd lean towards the 4 R1 volumes, but how busy is the database? If it's not stressed that much you might never see a...
June 16, 2008 at 10:43 am
Express is a production database, but on a personal level. It's designed to be used on a desktop, so if you have a production app that stores data on a...
June 16, 2008 at 10:38 am
That's what I suggest. Remove the constraints (or disable), delete, turn back on.
June 16, 2008 at 10:37 am
Do you have more information on what you're trying to achieve? Honestly this sounds like a test question, and I'd like to see you have produced some DDL or sample...
June 16, 2008 at 10:35 am
The space statistics sometimes don't update correctly or on the time you want. I haven't ever worried as this is a trend, longer term number and not a spot number.
The...
June 16, 2008 at 10:34 am
We're trying to nail this down.
Donations don't work since we have set gifts (book, shirt) that we give away to everyone, not to mentioned prizes that we purchase. We need...
June 16, 2008 at 10:29 am
Viewing 15 posts - 28,216 through 28,230 (of 39,804 total)