Viewing 15 posts - 13,291 through 13,305 (of 49,552 total)
IF EXISTS (SELECT 1 FROM OtherDatabase.sys.tables t inner join OtherDatabase.sys.indexes i on t.object_id = i.object_id WHERE i.name = 'IndexOfInterest' AND t.name = 'TableOfInterest')
PRINT 'Index Exists';
April 30, 2013 at 8:51 am
SQL Show (4/30/2013)
mah_j (4/28/2013)
4.What would happen if it is canceled during the rebuild or dbreindex ?Gail, dbreindex or alter reindex is not single unit of transaction? is it?
Rebuilding an...
April 30, 2013 at 8:44 am
Did you read the article I referenced? Specifically the section on replication and if necessary the kb article it links to?
April 30, 2013 at 6:46 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
April 30, 2013 at 6:04 am
adb2303 (4/30/2013)
GilaMonster (4/28/2013)
2) Up to you. Depends on your...
April 30, 2013 at 6:00 am
alistair.mc14 (4/30/2013)
April 30, 2013 at 5:01 am
mode_of_travel nvarchar(1100),
seat_type nvarchar(1100),
What kinds of seats or travel options require 1000 unicode characters to explain? I'd think of seat type as 'economy', 'premium', 'business', etc, not half a novel.
April 30, 2013 at 3:52 am
Temp table caching was added in SQL 2005 to alleviate the contention on the TempDB allocation pages caused by frequent creation of temp tables. You can probably find a few...
April 30, 2013 at 3:20 am
Something or someone (connected on session_id 51) ran two alter database statements there (or went and clicked them in the GUI)
ALTER DATABASE <db name> SET PAGE_VERIFY = NONE
ALTER DATABASE <db_name>...
April 29, 2013 at 4:07 pm
To disable TDE, one would run an ALTER DATABASE, that's all.
Take a step back, what was the last point in time when you knew that the DB was encrypted? How...
April 29, 2013 at 3:45 pm
fsuoj (4/29/2013)
GillaMonster,Our argument was not over SELECT statements but more over DML.
SELECT is a DML statement.
Exactly the same for insert, update, delete, why would a statement sent from across...
April 29, 2013 at 3:40 pm
Or someone could have disabled it manually. Should be in the default trace.
April 29, 2013 at 2:16 pm
Like with just about all database settings, SQL won't randomly change them for you.
Disabling TDE - ALTER DATABASE <db name> SET ENCRYPTION OFF.
April 29, 2013 at 2:04 pm
No, removing compression on a table or set of tables will not disable TDE. As for decrypting the pages, SQL does that every time they're pulled into memory, then they're...
April 29, 2013 at 1:35 pm
fsuoj (4/29/2013)
Would you consider it bad programming to use SQL Stored Procs vs. Adhoc queries?
No, absolutely not. Other way around.
His argument is that when you are hitting a large...
April 29, 2013 at 1:32 pm
Viewing 15 posts - 13,291 through 13,305 (of 49,552 total)