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';
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
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...
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
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?
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
April 30, 2013 at 6:46 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
April 30, 2013 at 6:04 am
adb2303 (4/30/2013)
GilaMonster (4/28/2013)
2) Up to you. Depends on your...
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
April 30, 2013 at 6:00 am
alistair.mc14 (4/30/2013)
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
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.
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
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...
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
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>...
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
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...
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
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...
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
April 29, 2013 at 3:40 pm
Or someone could have disabled it manually. Should be in the default trace.
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
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.
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
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...
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
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...
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
April 29, 2013 at 1:32 pm
Viewing 15 posts - 13,291 through 13,305 (of 49,552 total)