Skip to content

Commit 01bfdfd

Browse files
ktaranovktaranov
committed
Fix some bugs and code formating
1 parent 95b53e5 commit 01bfdfd

4 files changed

Lines changed: 17 additions & 15 deletions

File tree

‎Articles/README.md‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -667,6 +667,7 @@ Articles types:
667667
| [Oracle vs. SQL Server Architecture] | Kellyn Pot'vin-Gorman | 2019-03-20 | [DBA],[DEV] |
668668
| [Oracle RAC vs. SQL Server AG] | Kellyn Pot'vin-Gorman | 2019-03-28 | [DBA],[DEV] |
669669
| [SSIS vs. Oracle GG] | Kellyn Pot'vin-Gorman | 2019-04-10 | [DBA],[DEV] |
670+
| [Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?] | Shabnam Watson | 2019-04-13 | [DBA] |
670671

671672
[SQL Server Index Design Guide]:https://technet.microsoft.com/en-us/library/jj835095.aspx
672673
[SQL Server 2012 Security Best Practices - Microsoft]:http://download.microsoft.com/download/8/f/a/8fabacd7-803e-40fc-adf8-355e7d218f4c/sql_server_2012_security_best_practice_whitepaper_apr2012.docx
@@ -1311,3 +1312,4 @@ Articles types:
13111312
[Oracle vs. SQL Server Architecture]:https://dbakevlar.com/2019/03/oracle-vs-sql-server-architecture/
13121313
[Oracle RAC vs. SQL Server AG]:https://dbakevlar.com/2019/03/oracle-rac-vs-sql-server-ag/
13131314
[SSIS vs. Oracle GG]:https://dbakevlar.com/2019/04/ssis-vs-oracle-gg/
1315+
[Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?]:https://shabnamwatson.wordpress.com/2019/04/13/analysis-services-telemetry-what-information-does-ssas-submit-and-how-has-it-changed-in-ssas-2019/

‎Scripts/Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql‎

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
<documentation>
33
<summary>Create JOIN query between multiple tables dynamically.</summary>
44
<returns>SELECT statement from input table with INNER JOINS for all tables having foreign consttraints with input table.</returns>
5-
<issues></issues>
5+
<issues>Does not properly generate alias for case with multiply foreign keys for one table</issues>
66
<author>Konstantin Taranov</author>
77
<created>2019-04-22</created>
88
<modified>2019-04-23 by Konstantin Taranov</modified>
@@ -11,10 +11,10 @@
1111
</documentation>
1212
*/
1313

14-
DECLARE @schemaName AS sysname = N'dbo';
15-
DECLARE @tableName AS sysname = N'YourTable';
16-
DECLARE @tableFullName AS NVARCHAR(256) = QUOTENAME(@schemaName) + N'.' + QUOTENAME(@tableName)
17-
DECLARE @crlf AS varchar(10) = CHAR(10);
14+
DECLARE @schemaName AS sysname = N'dbo';
15+
DECLARE @tableName AS sysname = N'TableName';
16+
DECLARE @tableFullName AS nvarchar(256) = QUOTENAME(@schemaName) + N'.' + QUOTENAME(@tableName)
17+
DECLARE @crlf AS varchar(10) = CHAR(10);
1818
DECLARE @tsql AS nvarchar(max);
1919

2020
IF LEFT(@tableName, 1) = N'[' OR LEFT(@schemaName, 1) = N'['
@@ -67,8 +67,7 @@ WITH AllColumns
6767
XML PATH('')
6868
), N'') + N';';
6969

70-
7170
IF @tsql IS NULL
72-
PRINT('@tsql si NULL - something went wrong!');
71+
PRINT('@tsql is NULL - something went wrong!');
7372
ELSE
7473
PRINT(@tsql);

‎Scripts/IN_Memory_Example_2017.sql‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@ SELECT @databaseFilePath = SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf',
1111
WHERE database_id = 1 AND file_id = 1;
1212

1313
DECLARE @databaseName SYSNAME = N'1ಠಠಠ 16+ 错误的名字! Wrong Name! गलत नाम! Неправильное название! Nombre incorrecto! Falscher Name! 間違った名前! שם שגוי! Mauvais Nom!1';
14-
-- To prevent Msg 5135, שםשגוי cannot be used for FILESTREAM files
14+
/* To prevent Msg 5135, שםשגוי cannot be used for FILESTREAM files */
1515
DECLARE @dbFileName_mod SYSNAME = SUBSTRING(@databaseName, 1, 80) + N'_mod';
1616
DECLARE @databaseFileName NVARCHAR(1000) = REPLACE(@databaseName, N' ', N'');
1717
DECLARE @tsqlStatement NVARCHAR(4000) = N'';
@@ -59,7 +59,7 @@ N'/* configure recommended DB option */
5959
ALTER DATABASE CURRENT SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=ON;
6060
6161
/* memory-optimized table */
62-
CREATE TABLE dbo.[😁__間違った名前 In Memory Table Я не советую так называть__👻]
62+
CREATE TABLE dbo.[¯\_(ツ)_/¯ 😁__間違った名前 In Memory Table Я не советую так называть__👻 ¯\_(ツ)_/¯]
6363
( c1 INT IDENTITY PRIMARY KEY NONCLUSTERED,
6464
c2 NVARCHAR(MAX))
6565
WITH (MEMORY_OPTIMIZED=ON);
@@ -79,13 +79,13 @@ CREATE TYPE dbo.tt_table1 AS TABLE
7979
INDEX ix_c1 HASH (c1) WITH (BUCKET_COUNT=1024))
8080
WITH (MEMORY_OPTIMIZED=ON);
8181
82-
CREATE TABLE dbo.[😁__間違った名前 In Memory Table Я не советую так называть__👻](
82+
CREATE TABLE dbo.[¯\_(ツ)_/¯ 😁__間違った名前 In Memory Table Я не советую так называть__👻 ¯\_(ツ)_/¯](
8383
keyColumn INT IDENTITY PRIMARY KEY NONCLUSTERED
8484
, description CHAR(100) NOT NULL
8585
)
8686
WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA);
8787
88-
INSERT dbo.[😁__間違った名前 In Memory Table Я не советую так называть__👻]
88+
INSERT dbo.[¯\_(ツ)_/¯ 😁__間違った名前 In Memory Table Я не советую так называть__👻 ¯\_(ツ)_/¯]
8989
(
9090
description
9191
)
@@ -162,7 +162,7 @@ AS
162162
BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = N''us_english'')
163163
SELECT keyColumn
164164
,description
165-
FROM dbo.[😁__間違った名前 In Memory Table Я не советую так называть__👻];
165+
FROM dbo.[¯\_(ツ)_/¯ 😁__間違った名前 In Memory Table Я не советую так называть__👻 ¯\_(ツ)_/¯];
166166
END;' + CASE WHEN @debug = 1 THEN @crlf + N'GO' + @crlf ELSE N'' END;
167167

168168
IF @debug = 1 PRINT(@tsqlStatement)

‎Stored_Procedure/dbo.sp_BenchmarkTSQL.sql‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,8 @@ ALTER PROCEDURE dbo.sp_BenchmarkTSQL(
3131
Default value is NULL.
3232
3333
.PARAMETER @tsqlStatement
34-
TSQL statement for benchmarking. Mandatory parameter.
34+
TSQL statement for benchmarking.
35+
Mandatory parameter.
3536
No defaults.
3637
3738
.PARAMETER @tsqlStatementAfter
@@ -52,7 +53,7 @@ ALTER PROCEDURE dbo.sp_BenchmarkTSQL(
5253
Default value is 1 (true) - skip checking.
5354
5455
.PARAMETER @clearCache
55-
Clear cached plan for TSQL statement before each run.
56+
Clear cached plan for TSQL statement before each run using DBCC FREEPROCCACHE(@planHandle).
5657
Default value is 0 (false) - not clear.
5758
5859
.PARAMETER @calcMedian
@@ -344,7 +345,7 @@ BEGIN TRY
344345
DECLARE @median real;
345346
DECLARE @planHandle varbinary(64);
346347
DECLARE @startStep datetime2(7);
347-
DECLARE @endStep datetime2(7);
348+
DECLARE @endStep datetime2(7);
348349
DECLARE @stepDuration int;
349350
DECLARE @additionalXML xml;
350351

0 commit comments

Comments
 (0)