Viewing 15 posts - 47,581 through 47,595 (of 49,571 total)
And they have security implications. Dynamic SQL has its place, but it has a number of downsides.
January 28, 2008 at 7:52 am
Is the database in full recovery mode? Do you have any transaction log backups running?
Full backups don't truncate the inactive portion of the log. Only a transaction log backup does...
January 28, 2008 at 7:51 am
Looks like you're trying to use SQL authentication to a server that's configured for windows authentication only.
January 28, 2008 at 7:47 am
Can we see the table schema, indexes and the full execution plan please. Is nearly impossible to say anything for sure without those.
Since you're on SQL 2005 (I assume so...
January 28, 2008 at 7:45 am
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...
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...
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...
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.
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...
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.
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)
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...
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...
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...
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...
January 27, 2008 at 11:03 am
Viewing 15 posts - 47,581 through 47,595 (of 49,571 total)