Viewing 15 posts - 43,081 through 43,095 (of 49,571 total)
Sorts are expensive operations and distinct requires a sort, as do most other methods of removing duplicates from a resuuklt set.
The best 'workaround' is to find out why there...
November 20, 2008 at 10:27 am
Depends. How big is your database? How fast does it grow?
You shouldn't ever shrink a database. By doing so you've fragmented all of your indexes. I would strongly suggest you...
November 20, 2008 at 10:25 am
Mark (11/20/2008)
3) Remove builtin\administrators group
Just make sure there's another sysadmin account before doing that.
November 20, 2008 at 10:18 am
bkirk (11/19/2008)
Of course that is a very simple solution, however we need to keep it active for regular updates using 'sa' login.
Why? Quite frankly, as far as I'm concerned,...
November 20, 2008 at 10:09 am
What didn't you understand? What I posted is the syntax (as an example) of a grant statement that grants the permission to alter any user in the database Database1 to...
November 20, 2008 at 10:05 am
Likewise, and i know Grant is also - http://scarydba.wordpress.com/
November 19, 2008 at 4:43 pm
Very likely, because the index rebuild works by creating a complete new index before dropping the old one. So unless you have a fair amount of free space within the...
November 19, 2008 at 4:20 pm
tom (11/19/2008)
I was hoping to construct the WHERE clause in C# and send it as a single parameter and that does not appear to work.
no, it won't. SQL won't allow...
November 19, 2008 at 4:12 pm
That means whoever configured the Quest tool configured it to use the sa account and specified an incorrect password. Not the fault of the tool
November 19, 2008 at 4:10 pm
I feel that one of the best ways to find what you don't know is to study for a certification (or just check the MS site for the requirements) and...
November 19, 2008 at 2:22 pm
There's no direct way. You can use dynamic SQL and concatenate the where clause to the end of the string and execute that, but you open the system to sql...
November 19, 2008 at 2:00 pm
Jeff Moden (11/18/2008)
"You should be using derived column transformation, and use substring or available string functions. This would help." ... and that's...
November 19, 2008 at 1:55 pm
mikebally888 (11/19/2008)
Hi,Maybe you can try removed here too 😉 ,it is better than Crystal Report in many aspects
Where does anyone mention crystal reports, or any reporting tool for...
November 19, 2008 at 1:43 pm
arluna (11/19/2008)
I want to know if I use this nvarchar column in sql queries, to identify the rows, has performance problems
Shouldn't, as long as it's indexed
November 19, 2008 at 1:42 pm
mobile (11/18/2008)
- hacer new query en master.- alter database dbname set emergency
- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- dbcc checkdb ('dbname', repair_allow_data_loss)
- alter database dbname set multi_user
saludos
Repair should...
November 18, 2008 at 7:12 pm
Viewing 15 posts - 43,081 through 43,095 (of 49,571 total)