In this issue

Featured Articles

Editorial

Featured Script

advertisement
SQL Data Generator "I generated better data in only seconds..."
Michael Gaertner of Quintech was impressed with SQL Data Generator, a new tool for populating databases with realistic test data. Download your free trial of SQL Data Generator.
SQL Compare How to beat a hiring freeze
Use a tool that makes you shine. "SQL Compare saved the day for me and the company." Rob Fisch, Director of Global Technology, Kaz Inc. Download your free 14-day trial here.

Featured Articles

File Handling A Different Way

A different way for file handling through SQL Server.More »


SQLSaturday - Jacksonville

Coming in May is a free one day event in Jacksonville, FL.More »


SQL String User Function Workbench: part 1

Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.More »


SQL Server 2005 log shipping setup using the wizard

Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish. More »


Editorial - Table Level Access

I've been discussing LINQ with some people and someone brought up a very interesting point. With LINQ->SQL you need to grant table-level access for developers to use the interesting features of LINQ, at least the time-saving ones from what I've seen.

Or do you?

Is there enough of a benefit from LINQ and the associated but different Entity Framework? Personally I'm not sure because I'm not a deep developer, though I did get to talk to a few of the LINQ guys at Microsoft.

From their perspective, developers spend a good portion of their time writing queries and processing result sets when they could be building more of the features in their application. LINQ -> SQL is supposed to greatly reduce that time, saving developers a tremendous amount of time. I'm not sure how much time the average developer spends on writing queries and mapping the object to relational, but I'd be curious to know what some of you in the real world think.

You can still build views to encapsulate some security, and table-valued functions might be the other way to integrate with LINQ and still keep some control over what developers can do, security-wise. I'm not convinced that LINQ is a step forwards, but I am leaning that way. It's certainly being pushed and I'm not sure we'll see that stop anytime soon. I've been told a lot of engineering work went into ensuring that LINQ -> SQL doesn't allow any SQL Injection vulnerabilities, which would potentially be a very large reason to consider LINQ.

In any case, I would really be interested in hearing what some of the developers out there think about it's benefits, especially in terms of how much more productive it makes you.

Steve Jones

» Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

» To submit a tip, rant or editorial, log in to the Contribution Center


Question of the Day

Today's Question:

In SQL Server 2005, how would you rebuild a damaged master database?

Think you know the answer? Click here, and find out if you are right.

This question is worth 4 points in this category: Disaster Recovery. We keep track of your score to give you bragging rights against your peers.

We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center.


Yesterday's Question of the Day

There is a backup log task occurring and it is expected to take 20 minutes to clear out a stuck transaction. Someone asks if you can quickly run a full backup to use for reporting purposes since full backups normally take about 10 minutes. Can you start a full backup in SQL Server 2005 when a log backup is running?

Answer: Yes

Explanation: A full backup can be run simultaneously with a log backup, however not all administrative tasks can be done concurrently.

Ref: Concurrent Administrative Tasks - http://msdn2.microsoft.com/en-us/library/ms189315.aspx

» Discuss this question and answer on the forums


Featured Script

Alter Index with Rebuild

Alter Index with Rebuild Option More »


Database Pros Who Need Your Help!

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

Load Testing: what would you count? - Dear all, We are about to get much more users through our web based applications and we think we can't get...

need help for SQL Server2000 - dear friend i want to configer SQL Server in a domain network envairment. SQL server is installed in a client...

domain server problem - dear friends i am new in this fourm. i have a problem with connection to the sql server and clients i am...

How to check the table columns thru T-sql command - Hi, I want to check the columns that are present in one particular table. What is the T-Sql command to check the...

SQL Server Job Agent Job Category !!! - Hi pals, I am using sql server 2005. Is there any means to check/see the log if i add a new job...

Index Tunning Tools - Hi, Is there any index tunning tools for MS SQL 2005 better than its own one? Thanks,

Foreign key Referencing a column in another linked server - Hi, We're having a few linked servers in our company. some tables in one of the linked servers include columns...

Limiting impact of poorly designed queries - As a SQL Server DBA, what are the steps you can take to avoid letting poorly designed queries from swamping...

Sql Server Profiler 2005 - I got script from this helpfull site befor two years for crating trace file and log trace for my database...

Unable to create indexes just after updates on same table - One of out Stored procedure has list of update statement and just after the update there is Create Indexes on...

Prevent multilple logins per user - Hi folks, I'm looking for a way to prevent multiple logins for users on SQL Server 2005. Do you know a...

MMC could not create the snap-in. - Hello, Please help me to resolve this problem of mine, I've installed our SQL Enterprise Edition into Windows 2003 successfully. When...

SQL Server 2005 : Backups

Transaction Log Backup Size - Hello All I have a question regarding transaction log backup size. Here is the skinny. I have a db for which I...

Restore database from network drive - Hi All, All of our database servers are doing backups and saving the .bak files out on a network share. With...

SQL 2000 BLOCKING PROBLEM - [font="Arial"]We were facing the problem of SQL Blocking in SQL 2000.Not only this but also our users will have to...

SQL Server 2005 : Business Intelligence

show a report in html format without reportViewer control - Hello, my next step is to show this report in html format without reportViewer control, i used reportviewer, now i have...

MDX. Calculated member - I have an MDX query returning information. The query uses NON EMPTY keyword to clear the rows which have no...

Problem with tables with many to many relations - I have this kind of data base structure 1. Fact table (f) 2. Table that contains Countries and that is referenced to...

SQL Server 2005 : CLR Integration and Programming.

Performance Tool - SQL Profiler - I'm going thru the Wrox Book "Professional SQL Server 2005 CLR Programming" and am stuck on page 36, uppermost paragraph...

SQL Server 2005 : Development

A View Or a Stored Procedure? - Hello, I've got a table [b][CUSTOMERS][/b] with two fields (actually more, but it doesn't matter for my question): [b][CUST_NAME_EN][/b], [b][CUST_NAME_RU][/b]. [CUST_NAME_EN] is mandatory. My...

Records Accessing Problem - Hi friends, I have some problem when executing following VB Code that query not considering recently added records. Becuase of this...

Which dll is used for parsing query in sql server? - I wnat to create a small application like querry anlyzer in which i want to need parse the query. so...

Table Update Query -- Need Help! - I have the below data in a table called say "kipp". I am trying to get a script to work that...

HELP --- SQL Programming - I am new to SQL Server and need help fast.... If have the following table data... [font="Tahoma"]ProjProjID ProjStartDT ProjEndDT ------------------------------------ 88355 NULL NULL 88355.001 NULL...

SQL Server 2005 : SQL Server 2005 General Discussion

Help me in SQL Server installation - I have installed MS Visual Studio 2005 to do .net tutorials.My friends suggest me to be strong in back end...

Very Strange: SQL insert statement does not insert all the fields into table from Asp.net C# webpage - An insert statement was not inserting all the data into a table. Found it very strange as the other fields...

Issue with Datetime and precision - Dear All, Hope this is not too much of a Newbie question but I'm having a bit of an issue with...

Find who has last modified the Automated job - Hi, I would like to know, is there any option or sys table contains the information of the user who...

SQL Server 2005 sp2 database Mirroring problems - Hello, how guys how are you doing? I am new for database Mirroring but as i read i have prepared...

sp_who2 - sp_who2 shows the block by user and some information.Currently we are moving from sql 2000 to sql 2005. if i...

Synchronize SQL databases - Please can somebody help me with the following: Our company has an enterprize site (a very large one). From time to...

I need to reinstall the Sql Server 2005 Agent - i m not in a position to reinstall the server because there are heavy transactions on it live 24 /7...

SQL Server 2005 : SQL Server 2005 Security

Database owner and db_owner - (The problem came about when the developer want to back up their own database). Because i had owner as UserA When...

SQL Server 2005 : SQL Server 2005 Strategies

SQL Configuration analysis - Hi All I got a SQL server, that has been running normally, a few days back , i have made one...

SQL Server 2005 : SQL Server Express

Restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition - Can you restore a SQL Server Express 2005 database to SQL Server 2005 Enterprise edition? Seems like you can't. I...

Message: Timeout expired - Hi All, My clients (C# code) get Timeout exception when they try to download data and insert them into tables...

error - Hi, i am using sql server management studio 2005 to connect one of our database from sql server 2000 and...

Message Box In sql server 2000 - hi friends this is my first participation here in bref i have create a trigger on my table named customers...

SQL Server 2005 : SQL Server 2005 Performance Tuning

SELECT DISTINCT on Long Table - Hello, I have a table with over 10 million rows. Each row has one of 8 dates attached to it, roughly...

"Suspended" process caused by MS Access - I am using SQL 2005 x32 with SP2 installed. The Access database is connected to the SQL Server using ODBC linked...

SQL Server 2005 : SQL Server 2005 Integration Services

Date Format - hi, Right now i am using (DT_STR, 4, 1252) DAY( GETDATE() )+""+(DT_STR, 4, 1252) MONTH( GETDATE() )+""+(DT_STR, 4, 1252) YEAR ( GETDATE()...

Scheduling SSIS Packages - Hi, I am new to creating and deploying SSIS. I have created s SSIS package in BIDS, which I run manually daily,...

Execl Sheets looping - excel file is having more than one sheets of data with same strecture how to load that data into destination?...

Execute SQL and place results into email - Firstly I am new to Integration Services...so be gentle. I need to execute an sql 2005 stored proc and send an...

SSIS Package Scheduled under a SQL Job - I have scheduled a SSIS package under a SQL Job. This Job takes around 90-95 secs to initiate the SSIS...

SSIS ODBC Data Extract - Hi all, stuck again !! The situation is that I am trying to extract information via ODBC from a couple of systems...

Adding Tasks Programmatically - How can I add Execute SQL Task in the ForEach Loop container through C# code programmatically... Tried a lot with...

SQL Server 2005 : T-SQL (SS2K5)

Simplified WHERE clause??? - I have a sproc that filters on the SiteNumber field of a table but I also want to give the...

How to write update trigger in sql database with current system date - for example , database date 20/04/08 01:01:00 current date = 23/04/08 01:00:00 my query is i adding 3 days with database date ie, 20/04/08...

How to use Like Operator with VARIABLE - I want to apply like Operator in my searching time. but i dont use it before with variable. anyone pls...

adp,parameters in functions, subsequent views - I can not figure this out. Below is a portion of a view that has MULTIPLE other views run from...

Altering Column Values - Hi, I have one column with values something like this "A1704", "A2734", "CC404" and so on. I want to copy these...

CTE's are useless - Firstly, Forgive me. From my understanding CTE's replace subqueries. But when working with large data sets, is it not more effecient...

Substitute NULL value on converted date field? - Hi Guys. I have a select query as follows (sample code): [code] SELECT SalesOrderId, convert(varchar, Date, 103)AS ExpiryDate, Type FROM dbo.Values INNER JOIN SalesOrders...

Replace non numeric characters in string - Hi, I know the following code will replace single defined character (*) [code]REPLACE(Phone, '*', '')[/code] but I need to replace (remove) any non-numeric character...

SQL Server 7,2000 : Administration

xp_cmdshell with varbinary - Hi, has someone an idea, how to save a varbinary with xp_cmdshell? I try the following: DECLARE @cmd sysname; DECLARE @blob varbinary; select @blob=datei...

sql server in domain network - dear friends i am new in this fourm. i have a problem with connection to the sql server and clients i am...

Memory Allocation - Hi all, I have SQL Server 2000 Standard Edition Build 8.00818(SP3) Running on Windows 2003 Standard Edition SP2. I run Perfmon...

log shipping - hai! I faced a problem while doing log shipping with maintenance plan wizard in sql server 2000.I could create maintenance...

Database Question - Hi All, Could some one help me out with this question How would one be able to identify the commit rate on...

Login - Hi, I am notr getting clear with the difference between a login, user and a role. Can anybody receomend any website...

Changing the Primary data file of a DB - Hi, Is there a way of changing the primary data file in a DB to another one? I need to remove the...

Database file size at DB creation - Hi! Anyone knows a way to find out the initial size of a Primary data file? Since a data file cannot be...

SQL Server 7,2000 : General

Problem with calculated column formula - I've got the following formula in a calculated column: [code](case when ([ColumnA] = 'I') then (convert(char(4),[ColumnB])) else (case when ([ColumnC] = 1) then...

SQL Server 7,2000 : Working with Oracle

www.sqlservercentral.com - sir i have a problem while creating a procedure to insert values with a table containing foregin key please help

SQL Server 7,2000 : Security

creating a dev server with same security - Hi experts, We are/have created a dev server and want to apply the same security and logins to everything. It will...

SQL Server 7,2000 : SQL Server Newbies

Query with a Custom Order - Hi !! I've a problem: is there any way to choose a custom order of the return query output that is...

Return fields in record set? - Is it possible using a Stored procedure to return the field names that contain a certain value? as an example date field1...

SQL Server 7,2000 : Performance Tuning

Avoiding unnecessary I-O on checkpoints ?? - I'm going to throw this one out as it's beyond my understanding but looks and feels like extremely bad practice...

Access 2007 very slow with SQL server odbc connection (sql 2000) - We recently bought some new pc's with office 2007. Before we only had office 2000 and 2003. We use a...

SQL Server 7,2000 : Replication

Replication Sql Server 2000 - The merge process could not initialize the Publisher 'publisherServer :Xyz_Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147198719) --------------------------------------------------------------------------------------------------------------- Another merge agent for...

"There are already statistics on table" error 1927 - can not resolve - I have straight forward transactional replication set up on a SQL2000 database to a SQL 2005 database. The distribution agent is...

SQL Server 7,2000 : T-SQL

Can't INSERT into temp table - why? - I'm doing the following - points of note include 1) I can create the table with no trouble, 2) I can...

duplicate rows and batch abort - I was wondering about some behaviour in SQL when it comes to inserting duplicate keys... I created a table in EM...

Removing the JUNK Characters - Dear All, I want to remove the JUNK characters from Remarks column. Say for example, Create table Emp ( Eno int, Salary money, Remarks ) Insert into Emp Select 1,5000,'Bon#us&@amount' union...

Query with a custom order - Hi !! I've a problem: is there any way to choose a custom order of the return query output that is...

Concatinate SP always return NULL? - Hi All, Any ideas why this always returns NULL? Help would be greatly appreciated! DECLARE @Count int DECLARE @sql NVARCHAR(2000) SET @Count = 1 WHILE @Count...

How to Export Result Set to Excell file - Hi Gurus, I have one stored procedure which will give me Execution time taken of all of the views as a...

what is the difference between CAST and CONVERT Function? - what is the difference between CAST and CONVERT Function? which one is preferred?

how can I pass a TEXT field to eXtended Stored proc? - Hi... I wrote a routine for encoding in Base64 algorithm and integrate in an extended stored procedure, it works fine when...

query to find space usage of each column in a table - We a table of abnormal size and need to find usage by each column in the table. Below is the structure...

Order by Numeric value of a Varchar column Need a better solution - I have a column called TradeReference which mostly contains Numeric value (for referring the Trade orders). But it may occasionally...

Finding Date & time from a string - Hi all I would be grateful if someone please help me to find date and time from a given string . the...

Find Affected Row Count from a Dynamic Query - Dear Gurus, Following is my procedure CREATE PROCEDURE prg_SHOW_VIEW_RUNNINGTIME ( @strViewName NVARCHAR(255) ) AS BEGIN DECLARE @strSql NVARCHAR(400) ,@dtStartTime DATETIME ,@dtEndTime DATETIME ,@rowcount INT SET @dtStartTime = GETDATE() SET @strSql = 'SELECT * FROM...

Date conversion - Hi, Can anyone tell me how to convert a datetime (or smalldatetime) value into MM/YYYY format while still retaining date functionality...

How to getRecordCount (Like Sr. No.) in a selectCLause Query in Sql Seevr 2000 - Hi, I had a Following simple Select Query in Sql Seevr 2000. Select City_Name From City_Master It return RowSet Like CityName ------------- Ahmedabad Delhi Mumbai Banglore but , i want like...

Query Help - 3 - Dear All, I want to search a particular patterns from a given string. Ex: 'Select CompanyName,CompanyId,Dept,Manager from Company A,Department B,Manager C where A.CompId...

Query Help - 2 - Dear ALL, I have one senario. Create table ColumnDetails ( ID int, ColumnName varchar(4000) ) Insert into ColumnDetails Select 1,'Select A.Eno,A.Ename,B.Dept from Emp a,Dept b where a.Eno = b.Eno' Union...

Programming : XML

XML - Hi, Can anyone help me regarding xml :). I'm currently searching and reading articles, forums regarding generating records from sql to...

Deserialize data in xml column to a table - I absolutely love XML data type but I think I have reached my limits on this new requirement I am...

Reporting Services : Reporting Services

HOW TO CREATE DASHBOARDS IN SSRS - HI can anyone tell me how to create dashboards in ssrs. thanks in advance

Optional grouping depending on selected parameter in reporting services - Hi, I have a report which can be executed by selecting different companies from the parameter field. The report is grouped...

How to simply the report Deployment process ? - I have 5 SQL Servers and totally around 100 databases (1 database for 1 client). Whenever I finish a Report...

SQL Server Reporting Services 2005 - I'm using SQL Server Reporting Services 2005 and I'm trying to create a report. Again and again I'm getting this...

calculate between two dates - Hi, I have 3 Dimensions and a FactTable in my cube, How do I perform calculations between the two dates to...

Reporting Services : Report Development

Can i do this in reporting services - I have a main report and some subreports. What i want to achieve is the subreports would be dynamically sent parameters...

Data Warehousing : Integration Services 2005

Custom Logging In SSIS - Hi All , I am currently working on a custom error Logging dll , which will capture the errors that would occur...

Data Warehousing : Data Transformation Services (DTS)

How to export sql server data into multiple excel sheets ? - [b]How to export sql server data into multiple excel sheets ? [/b] I don't want to do this from DTS or SSIS....

OSQL Tab Delimited Text File - Hello, I've got two problems with this task: First, I could get the file to be created in a tab delimited format...the...

Testing Center : SQL Server Security Skills

How can I unencrypted a stored procedure - I got few stored procedures With Encryption for the database that I converted to SQL Server 2000.   I need to...