|
|
-
25
Liked
| 27
Learned
| 3
Comments
|
|
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), '"-...
|
|
-
|
|
sql bi - product name change alert: vertipaq is now refferred to as xVelocity...
|
|
-
|
|
It's quite old, but new for me. Great method to parse string is using of recursive CTE, as showed in Table Function:
CREATE FUNCTION fn_SplitString(@str NVARCHAR(MAX), @sep NVARCHAR(MAX))
RETURNS TABLE
AS
RETURN
(
WITH sepPos ...
|
|
-
|
|
If you do not need them: Go to pivot-table options > Totals and filters > **uncheck** Show Grand Totals for rows/columns...
|
|
-
|
|
I was watching today's [Mar 7 2012] launch event sessions, when in one of the session on Powerview, the speaker mentioned that one can export PowerView reports to powerpoint (ppt) - Not only that, There's a **"click to interact"** button on slides that ...
|
|
-
|
|
to find locked tables in SQL Server 2005 ,
> sp_lock
and use Object_Name() to find out name of the table,
> SELECT Object_Name(ObjectID)
...
|
|
-
|
|
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has been ...
|
|
-
|
|
Todays [Just Learned] tip is:
- CHECKSUM - where you can count hash value
of entire row (or only set of columns) -
horizontal; Useful for creating own
index (for example for long
strings), for validation of changed
values, and so ...
|
|
-
|
|
I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this I h...
|
|
-
|
|
Set the report's **AutoRefresh** property with the number of seconds.Press 'F4' on the report for open properties window. ...
|
|