|
|
-
|
|
Spreadsheet is widely used by people in every industry due to flexibility for business data computing and analysis as well as visualized calculation. The nontechnical people can perform some rather complex calculations without having to learn the SQL. But the common business spreadsheet can't conduct relational query....
|
|
-
|
|
FILESTREAM data can be accessed by TSQL as well as through the Win32/Managed APIs. Accessing FILESTREAM data using TSQL is not recommended for a number of reasons such as the inability to stream data when reading or writing through TSQL. The recommended...
|
|
-
|
|
Extending the Windows user experience of file searches to SQL server is a bit of a challenge because the asterisk [*] is a wild-card character in Windows whereas SQL Server uses percentage [%]. The percentage [%] is valid in a file name which adds to the complications. Today's post presents an approach to realize such a requirement using the ESCAPE keyword....
|
|
-
|
|
The currency symbol $ represents the value 0. Find more examples at http://beyondrelational.com/modules/1/justlearned/tips/8577/arithmetic-operations-with-.aspx
The datatype of the returned value from $ is money.
Consider the following exampledeclare @...
|
|
-
|
|
Few days back, i was working to add new table in publication in transaction publication. After adding a article in publication and after reinitialized, i see nonclustered index was not copied at subscriber database. I tried reinitialized one more time a...
|
|
-
|
|
Hi all , On PASS Business Analytics Conference(PBAC) in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download Here ). "Today we are announcing the availability of the project codename "GeoFlow" Preview for Exce...
|
|
-
|
|
Changing the SQL Server collation once a SQL Server instance has been installed is a tedious process because it involves recreating the master database. Many believe that the server collation is picked up by default and must be changed by master database recreation only. In this post, I show how to ensure that the installation itself always uses the required collation....
|
|
-
|
|
This post is triggered by a question I recently saw in the BR Forum asking ideas for merging two XML documents. I thought of adding another installment to the XQuery Labs series to explain how this can be done from TSQL when required. The examples giv...
|
|
-
|
|
Forgetting the "sa" login is an issue frequently seen in development & QA environments. Generally the Windows login works, but in some cases the IT team who installed the server may have forgotten to add someone to the sysadmin role. This post provides a proactive recommendation and link to a workaround....
|
|
-
|
|
A few days back, while i was working with Alerts for failed scheduled jobs and missing scheduled jobs, i was needed to exclude running jobs. So we can exactly know which jobs are actually failed excluding running jobs and sane case for missing jobs. I a...
|
|