Viewing 15 posts - 2,506 through 2,520 (of 49,552 total)
PJ_SQL (8/28/2016)
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
August 29, 2016 at 6:20 am
coool_sweet (8/28/2016)
i am not finding it anywhere
I assure you, there's information on the isolation levels in the official documentation (Books Online)
yes interview question
The point of interview questions is to see...
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
August 29, 2016 at 1:39 am
coool_sweet (8/28/2016)
(2) can a table have only non cluster index?
(3) Design a package to transfer 10 files from FTP and store them to hard drive?
(4)What is self...
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
August 28, 2016 at 3:50 pm
Eric Mamet (8/28/2016)
This is brilliant for small businesses!Is it new in 2016, or did I miss it in 2014?
It's been like this since there was an Analysis Services (SQL...
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
August 28, 2016 at 1:28 pm
It depends both on the total size of the table, and on the number of rows needing a lookup.
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
August 28, 2016 at 1:27 pm
Depends on the table size and number of rows needing a lookup. Test for your data set and see which works better for you.
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
August 28, 2016 at 1:58 am
Assuming you know there is only one non-zero leading digit, doesn't matter how many zeroes there are
DECLARE @Number BIGINT;
SET @Number = 1000000017777;
SELECT CAST(RIGHT(@Number, LEN(@Number) - 1) AS INT);
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
August 27, 2016 at 3:44 pm
erico (8/27/2016)
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
August 27, 2016 at 3:40 pm
https://msdn.microsoft.com/en-za/library/ms189799.aspx
Permissions
To create a DML trigger requires ALTER permission on the table or view on which the trigger is being created.
To create a DDL trigger with server scope (ON ALL SERVER)...
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
August 27, 2016 at 12:13 pm
Ok, so if you're after performance improvements, why are you wasting time looking at partitioning?
Partitioning is for data management, fast loads, archiving, that kind of thing, if if you...
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
August 27, 2016 at 5:32 am
Depends. Why are you partitioning the table?
The purpose behind the partitioning will determine what your partition columns should be.
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
August 27, 2016 at 3:40 am
DaleB (8/26/2016)
In the context of this thread why is a detach/attach upgrade process more risky than a backup/restore?
Mostly because it doesn't leave you an intact copy of the DB on...
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
August 27, 2016 at 3:36 am
erico (8/25/2016)
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
August 27, 2016 at 3:31 am
phonetictalk (8/26/2016)
And when you turn left at a red light, a lot of people stare. :hehe:
Yes, because unlike in the US, turning left (would be right for the US) through...
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
August 26, 2016 at 4:36 pm
Steve Jones - SSC Editor (8/26/2016)
Thanks, we are thinking to try and get up to Inverness and maybe beyond
If you're going up to Inverness, take the train from Edinburgh. Goes...
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
August 26, 2016 at 4:29 pm
Viewing 15 posts - 2,506 through 2,520 (of 49,552 total)