|
|
-
|
|
Removing the Calculate statement from the beginning of your MDX script has the same effect as setting the AggregateFunction property of all measures to none.......
|
|
-
|
|
I encountered an error mentioned in title from log reader agent after reinitialize all subscription for one publication and it stopped working. This is due to replication object was not created for insert and named like 'sp_MSins_TableName'.
The sol......
|
|
-
|
|
I just learned one new thing today "How to know Maintenance Plan name,description,create date,owner information with using system table sysmaintplan_plans in MSDB Database,all Maintenance Plan related data stored in MSDB database." Check out following q......
|
|
-
|
|
Microsoft have released three more learning snacks focussed on SQL Server 2012. These provide short, sharp introductions to SQL Server 2012 improvements......
|
|
-
|
|
You wanna create your picture in SQL? It is possible using geometry datatype. Only thing you get your picture in SVG format and get the values for geomerty. It would enbale the spatial result tab in SSMS and show your picture. (Read the comments especia......
|
|
-
|
|
The following script helps to find columns which have special characters other than alphanumeric, in a given database. If some special character for example under score "_" as part of column name and want to ignore, include special character with escape......
|
|
-
|
|
When we use select count(*), the query processor will use scan on the index with the smallest number of pages to find the result of select(*).......
|
|
-
14
Liked
| 12
Learned
| 4
Comments
|
|
During working with replication, encountered with one error to use actual server name for replication. For solution we need to change the SQL Server instance name as actual server name with following,
[CODE]
EXEC sp_dropserver 'Old Server Name'
EXE......
|
|
-
13
Liked
| 14
Learned
| 0
Comments
|
|
Recently learned from Ana's blog here that, in Denali, now execution plan will show some warnings also. While executing query, if it finds any bottlenecks, it will show the warnings in the execution plan against that iterator.
When you see the actual......
|
|
-
|
|
The Microsoft Office 12.0 Access Database Engine OLE DB Provider can be used to consume Microsoft Access and Microsoft Excel data sources in 64-bit environments......
|
|