|
|
-
|
|
There was a question in the forum on how to Sort mixed value strings “numerically”
Consider the following set of datacreate table #test(val varchar(10))
insert into #test
select '1002' union all
select '29C' union all
select '1' union all
select '205' u...
|
|
-
|
|
A couple of months back, I had written a post on ‘Measure selection using Slicers in PowerPivot’ and this turned out to be one of my most popular ones in the PowerPivot / DAX category. It was just a matter of time before someone asked how to do the same...
|
|
-
|
|
Converting Base64 values to varbinary and vice versa can be realized with the help of XQuery functionality available from SQL Server 2005 onwards...
|
|
-
|
|
Primary data files are always assigned a file_id = 1 in the sys.database_files view. But, what about the log and rest of the data files? Does the primary transaction log file of a database always receive a file_id = 2?...
|
|
-
|
|
Earlier I wrote a post for the same error at Review of some replication issues and workaround but it is just overview with some other replication errors also. I have published some of posts related to replication which you can reach with following links...
|
|
-
|
|
Is there a limit upon the number of characters that can be displayed in the query execution results displayed in the "Text" mode in SSMS? In this post we discuss how to change the maximum characters that can be displayed per column....
|
|
-
|
|
Following up Question of the month December 2012 - Why is last comma ignored in CREATE TABLE statement? , here is same question on TABLE VARIABLE
The last comma in permenant and temporary tables are ignored when you run the followingCREATE TABLE emp(emp...
|
|
-
|
|
The Microsoft Virtual Academy has just released a free course covering SQL Server Essentials for Oracle DBA’s. This is a Level 200 course containing 15 modules (each consisting of a video presentation, demos and a slide-deck) and while it’s intended to...
|
|
-
|
|
We all use Excel in our daily activities and here are
the series of posts which can help to learn.“Watch, learn from and be Inspired in
your own Life – because Champion is made not Born.”
What
Is Excel Good For?
Excel is the world’s popularly used sp...
|
|
-
|
|
Recently, while I was working on SSIS packages, I encountered an error “ A buffer failed while allocating .. bytes”. Entire package was working perfectly when the number of rows transferred were optimal. However, as soon as the package started loading ...
|
|