Viewing 15 posts - 18,346 through 18,360 (of 49,552 total)
SQL Kiwi (5/31/2012)
Greed. Steve pays me $50 per post.
I clearly need to ask Steve for a raise. About 200% would be nice.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 10:16 am
Interesting... Please run your query again, but put the [] around the name like I did.
Also
SELECT * FROM sysusers where uid = 11
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 9:48 am
Read up on EXECUTE AS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 7:43 am
Why persist it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 5:26 am
Haven't used unix since university. Maybe depends on the file type, but the vast majority of data files that you'll encounter on windows (SQL data and log file, word docs,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 4:36 am
tilew-948340 (5/30/2012)
I guess that today there is a converter by default on Window7 ...
No converters. Most data files are identical between 32 bit and 64 bit (an app dev would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2012 at 2:04 am
David Webb-200187 (5/30/2012)
For #2, it depends. The answer you gave will verify that your backup matches your database
Doesn't even do that (unless the backup was taken with a specific...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 3:08 pm
Koen Verbeeck (5/30/2012)
GilaMonster (5/30/2012)
I have a good beer bread recipe if anyone want... 😉 :hehe:Why not 🙂
http://www.food.com/recipe/beer-bread-73440
Seriously good (and that's from someone who can't stand the smell or taste of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 2:38 pm
I have a good beer bread recipe if anyone want... 😉 :hehe:
Seriously though, I had the chance to visit a beer fest while in the UK, astounding variety. Here there's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 2:28 pm
Jack Corbett (5/30/2012)
GilaMonster (5/30/2012)
Too snarky?http://www.sqlservercentral.com/Forums/Topic1306465-334-1.aspx
Hard to say because the content of the question(s). I'd have a hard time not coming across as snarky if I posted...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 2:10 pm
select '[' + name + ']' as objectname, uid from sysobjects where name like '%BRP001_ACCT%'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 2:09 pm
SKYBVI (5/30/2012)
Then why there are so many links for SQL Server DBA interview questions
Because there are lots and lots of people who want to cheat their way to a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 2:07 pm
What's the error when you try to delete it (try DROP TABLE, not via EntMan) and has someone been messing with direct updates to the system tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 1:57 pm
Good question. Some days I ask myself that...
I started because I wanted to get better at SQL, to be faced with problems that I did not have at my job...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 1:29 pm
Brandie Tarvin (5/30/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 30, 2012 at 12:18 pm
Viewing 15 posts - 18,346 through 18,360 (of 49,552 total)