Viewing 15 posts - 47,566 through 47,580 (of 49,552 total)
Unfortunately SQL 2000 does not have any built-in encryption routines.
Your best bet is probably to write a front end and use the windows cryptography APIs to encrypt the card...
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
January 28, 2008 at 7:42 am
mark.rozario (1/28/2008)
well nothing gets printed out, because of that error in syntax.
If you double click the error message (in management studio) it will take you to the line of 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
January 28, 2008 at 5:37 am
There's no problem having the nonclustered indexes on a different file group from the clustered index (which is actually the table). If the file groups are on different drives, 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
January 28, 2008 at 5:32 am
JMSM (1/28/2008)
how can i make one 'update statistics.......... for all indexed columns'
Update Statistics <Table name> That will update all the statistics on that table.
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
January 28, 2008 at 5:24 am
Steve Jones - Editor (1/27/2008)
You can use Gail's suggestion, but building queries like this is inefficient and can cause you performance issues with large data sets.
I was thinking the same...
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
January 28, 2008 at 1:07 am
If you print the command that you're building up, what do you get?
As for monthly automation, create a SQL Agent job and set up a monthly schedule.
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
January 28, 2008 at 12:59 am
Close
SELECT * FROM tbl WHERE ID = @param2 AND QTY = (CASE WHEN @param1 IS NULL THEN @param3 ELSE @param4 END)
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
January 27, 2008 at 12:15 pm
Easiest way to do this (I think) is with a 'tally' table. Lots of examples around here. Essentially, it's just a table filled with numbers and/or dates that you can...
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
January 27, 2008 at 11:54 am
No lock's not something you should be using all the time. It's for when you have concurrency issues and you don't mind the chance of inaccurate data.
Selects can be run...
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
January 27, 2008 at 11:13 am
The ldf file is the transaction log. You can shrink it using DBCC shrink file, though if you have the necessary backups and such it should never be necessary.
The mdf...
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
January 27, 2008 at 11:08 am
Not criticising, but the two levels 'SSChasing Mays' and 'Right there with Babe' are fairly meaningless to someone without knowledge of whatever sport they refer to.
p.s. Just got over 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
January 27, 2008 at 11:03 am
Balaji (1/26/2008)
I dont think 1=1 is necessary in where criteria. is it affect performance?
Not necessary at all. It shouldn't affect performance. The optimiser should be smart enough to ignore 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
January 27, 2008 at 10:59 am
JMSM (1/27/2008)
People who works here tell me that they dettach the database where this query is...
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
January 27, 2008 at 10:56 am
You said you were going to store it as a numeric and do all the manipulations and editing in the front end. Do the same, just have it as 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
January 27, 2008 at 5:58 am
Ok, so you have no indexes other than the primary keys (from the code you posted). Is that correct?
I'm just guessing without knowing the rows involved, but perhaps indexes on...
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
January 27, 2008 at 5:52 am
Viewing 15 posts - 47,566 through 47,580 (of 49,552 total)