Viewing 15 posts - 45,256 through 45,270 (of 49,552 total)
SQL injection isn't actually a SQL Server vulnerability. Somewhere you have an application, most likely a web application that is using ad-hoc SQL statements to communicate with the database.
The...
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
August 7, 2008 at 4:31 am
ch.mohini (8/6/2008)
can i detach master
Why do you want to? What is it that you are trying to do?
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
August 7, 2008 at 4:19 am
Visual Studio Team System Database Edition (aka Data Dude) contains a random data generator.
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
August 7, 2008 at 4:19 am
Very strange. As a suggestion, download one of the evaluation versions of SQL Server, install the client tools somewhere and use profiler to watch what's happening to the DB.
What'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
August 7, 2008 at 4:15 am
Without seeing any more info on this, it's hard to make a blanket statement. Generally what I would do is index for the most frequent queries. If you don't know...
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
August 7, 2008 at 4:14 am
Depends on the mail. Mostly on what its asking and the way its been asked.
If the mail is rude or demanding or written in half-legible english it will get...
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
August 7, 2008 at 4:10 am
I haven't gone over the code in detail, but one thing jumps out. This is only going to work properly when a single row is updated.
set @CHA_OID = (select APV_APT_OID...
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
August 7, 2008 at 4:08 am
rbarryyoung (8/6/2008)
Does anyone know when RC1 will be available? I have seen some folks say that they have it, but I can not find it at the Download center.
RC1...
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
August 7, 2008 at 3:46 am
There are a number of us on LinkedIn. There's even a SSC group there.
Personally I prefer to keep connections and especially recommendations to friends or people that I have worked...
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
August 7, 2008 at 3:43 am
http://summit2008.sqlpass.org/
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
August 7, 2008 at 3:35 am
When using dynamic SQL, the user needs permission on the base tables. The dynamic SQL breaks the ownership chains.
You may be able to remove the dynamic SQL. I don't know...
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
August 7, 2008 at 3:31 am
Please don't post in all capitals. It's the online equivalent of shouting at someone.
First thing is to find out why the procedure is slow. Are there cursors, while loops or...
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
August 7, 2008 at 3:25 am
Not within one instance. SQL treats all databases equally. If you need to do this, and the databases don't refer to each other, you could install a second instance and...
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
August 7, 2008 at 3:08 am
siddartha pal (8/5/2008)
Thanks alot for the inputs. There is lot of material available on net and its difficult for me to know which one is good.
Most of the free...
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
August 7, 2008 at 3:02 am
Manie Verster (8/2/2008)
Heh, heh, heh I have a surprise for you!!! I am a developer and proud of it.
Guess what. You ain't the only one.
I do hope there...
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
August 2, 2008 at 1:18 pm
Viewing 15 posts - 45,256 through 45,270 (of 49,552 total)