|
|
-
Bogdan Sahlean Commented 1 Years ago through Just Learned | 1 Point
[`WHERE filter GROUP BY ALL solution`] is less efficient than [`AggFunction( CASE WHEN ... END )`] because SQL Server will scan (Table Scan) the same table two times.
For these two solutions:
PRINT '***Solution1***';
SELECT ProductGroupID...
|
-
Bogdan Sahlean Commented 1 Years ago through Just Learned | 1 Point
[`WHERE filter GROUP BY ALL solution`] is less efficient than [`AggFunction( CASE WHEN ... END )`] because SQL Server will scan (Table Scan) the same table two times.
For these two solutions:
PRINT '***Solution1***';
SELECT ProductGroupID...
|
-
Bogdan Sahlean Commented 1 Years ago through Just Learned | 1 Point
[`WHERE filter GROUP BY ALL solution`] is less efficient than [`AggFunction( CASE WHEN ... END )`] because SQL Server will scan (Table Scan) the same table two times.
For these two solutions:
PRINT '***Solution1***';
SELECT ProductGroupID...
|
-
Bogdan Sahlean Commented 2 Years ago through Just Learned | 1 Point
Both ODBC functions (`{fn extract(minute from getdate())}` and `{fn minute (getdate())}`) are translated into `datepart(minute,getdate())` ....
|
-
Bogdan Sahlean Commented 2 Years ago through Just Learned | 1 Point
Both ODBC functions (`{fn extract(minute from getdate())}` and `{fn minute (getdate())}`) are translated into `datepart(minute,getdate())` ....
|
-
Bogdan Sahlean Commented 2 Years ago through Just Learned | 1 Point
Both ODBC functions (`{fn extract(minute from getdate())}` and `{fn minute (getdate())}`) are translated into `datepart(minute,getdate())` ....
|
-
Bogdan Sahlean knew 2 Years ago through Just Learned | 1 Point
Today I learned from Niladri's blog about the keyword "Using", which greatly simplifies joining relationship between 2 queries.
General Syntax :
[code]
Table1 t1 join table2 t2 on t1.DeptId = t2.DeptId;
[/code]
Using Syntax :
[code]
Table1 jo...
|
-
Bogdan Sahlean knew 2 Years ago through Just Learned | 1 Point
Today I learned from Niladri's blog about the keyword "Using", which greatly simplifies joining relationship between 2 queries.
General Syntax :
[code]
Table1 t1 join table2 t2 on t1.DeptId = t2.DeptId;
[/code]
Using Syntax :
[code]
Table1 jo...
|
-
Bogdan Sahlean Liked 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog that by using DBCC SQLPERF, we can clear the wait stats.
[code]
DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);
[/code]......
|
-
Bogdan Sahlean knew 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog that by using DBCC SQLPERF, we can clear the wait stats.
[code]
DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);
[/code]......
|