Viewing 15 posts - 43,081 through 43,095 (of 49,566 total)
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
I'd suggest disabling the sa account
November 18, 2008 at 7:11 pm
J (11/17/2008)
I have always found your writings very interesting.
Regarding your solution, it is not immediately clear how your suggestion works in terms of being less susceptible to attack. Would...
November 18, 2008 at 7:06 pm
How about
SELECT * FROM sysusers where name = 'sys'
November 18, 2008 at 6:52 pm
On 2005, not easily. You can create an indexed view and put a unique clustered index on that, or you can define a calculated column and put the constraint on...
November 17, 2008 at 12:12 am
Viewing 15 posts - 43,081 through 43,095 (of 49,566 total)