SQL Server: What I Have Learned in May 2011 (connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 24 days ago

What i have learned and shared about SQL Server during month of May 2011 read more...

add a comment |category: Database |Views: 19

tags: Database another

Dedicated Administrator Connection – Underappreciated Features of Micr(beyondrelational.com)

submitted by jacobsebastian(3639) 11 months, 25 days ago

Today’s post is part of the series that I am running under the title " Under Appreciated Features of SQL Server ". The series has been inspired by Andy Warren's editorial on SQLServerCentral.com. How often have you faced a situation wherein while the host operating system is perfectly operational... read more...

add a comment |category: Database |Views: 12

tags: Database another

Filtered index in SQL Server 2008(www.dotnetlogix.com)

submitted by dotnetlogix(524) 11 months, 27 days ago

A filtered index in an optimised nonclustered index, specially designed to index a sub set of data i.e, a portion of rows in as table. read more...

add a comment |category: Database |Views: 9

tags: Database another

SQL Server: How to Analyze Ad Hoc Queries Workload(blogs.dotnetkicks.com)

submitted by lionofdezert(1110) 11 months, 28 days ago

Lets figure out work pressure of Ad Hoc queries. read more...

add a comment |category: Database |Views: 8

tags: Database another

SQL Server: Create/Drop Scripts for All Existing Foreign Keys(connectsql.blogspot.com)

submitted by lionofdezert(1110) 11 months, 29 days ago

How to get create and drop script for all of your existing foreign keys in a specific table or whole database. read more...

add a comment |category: Database |Views: 9

tags: Database another

Copy Database from Instance to Another Instance – Copy Paste in SQL Se(blog.sqlauthority.com)

submitted by pinaldave(9662) 11 months, 29 days ago

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with necessary security permissions. You can automate this process as well control error logging. Following are the steps to copy database from one instance to another instance. read more...

add a comment |category: Database |Views: 43

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL Server: Shortcuts for TSQL Code in SSMS(connectsql.blogspot.com)

submitted by lionofdezert(1110) 1 year ago

Why I should type SELECT * FROM all the time ? I want to type just * and it must be converted to SELECT * FROM on enter or tab button press. If you wanna get ride of these common scripts typing again and again and just give SQL Server Management Studio a hint to write tsql itself, this tool is for you. read more...

add a comment |category: Database |Views: 20

tags: Database another

A case of avoiding Eager spool(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year ago

"When I was looking the plan cache for the queries having “Table spool”, I came across this query.INSERT INTO @Result (OID,Partkey) SELECT OID, dbo.fgetPartKey(OID) FROM fn_getSplit( @P_OIDS,',' ) WHERE OID > 0 Query optimizer used the below plan to execute the above query. " read more...

add a comment |category: Database |Views: 19

tags: Database another

SQL Server: Which Performs Better, IN or EXISTS (connectsql.blogspot.com)

submitted by lionofdezert(1110) 1 year ago

As compared to EXISTS, IN is more commonly used, but which one is more efficient? That’s what we are looking for, today. read more...

add a comment |category: Database |Views: 16

tags: Database another

What is new in SQL Server Code-Named “Denali”? (www.techbubbles.com)

submitted by kalyanms1(1789) 1 year ago

This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008 R2 as it is purely a BI release. You can download the Denali CTP version from here read more...

add a comment |category: Database |Views: 27

tags: Database another

Creating SQL Server Database Objects Backup using SMO (www.techbubbles.com)

submitted by kalyanms1(1789) 1 year ago

This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore them back to the server. read more...

add a comment |category: Database |Views: 5

tags: Database another

SQL Server:A Quick Intorduction to tempdb(blogs.dotnetkicks.com)

submitted by lionofdezert(1110) 1 year ago

What is tempdb, and what type of objects of my databse use tempdb. read more...

add a comment |category: Database |Views: 27

tags: Database another

SQL Server: How to Remove Special Characters (connectsql.blogspot.com)

submitted by lionofdezert(1110) 1 year ago

One more useful function from my query bank, which I like to use to remove special characters from a string. read more...

add a comment |category: Database |Views: 30

tags: Database another

SSRS: Configure User Authentication with ReportCredentials(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year ago

Many times I found that the Reporting service is configured to access as "Anonymous Access", so any user having URL can access reports from external world. Ideally it should be access by only users/application. For that SQL SERVER Reporting service should not be accessed by "Anonymous... read more...

1 comment |category: Database |Views: 25

tags: Database another

SQL Server: Convert Multiple Spaces to Single Space in a String(connectsql.blogspot.com)

submitted by lionofdezert(1110) 1 year ago

Extra spaces between characters of a string value is a common problem and if you’re a developer then you must have faced the problem. On request of a blog reader here is a script from by query bank which I like to use to remove such extra spaces. read more...

add a comment |category: Database |Views: 18

tags: Database another

SQL Server: Query Template, a Time Saving Feature (connectsql.blogspot.com)

submitted by lionofdezert(1110) 1 year ago

If you have same script for multiple occasions and you just make changes by find replace method then Query Template can save your time. read more...

add a comment |category: Database |Views: 37

tags: Database another