Hi Stackers After reading Bil Simser blog post Being a Better Developer... in 6 months I agree with his headlines which are: • Reading • Writing • Speaking • Community • Learning • Code, Code, Code and more code But I’ve a specific question "How to be a better database developer (specially Sql-Server developer)" and ...
With SQL Server, I can send SELECT * FROM FOO SELECT * FROM BAR to the server and get back the results of both, all in one trip. Can I do that with mySQL also? ...
I have like 20 or so tables in the database RentalEase and I want to print them out (physically) so I can look at them easier. I don't care too much about what data is in them, just their structure. How can I do this? It's an SQL Express server and I'm using Microsoft SQL Server Management Studio Express to manage it. I remember back wh...
Hello all, I have problem with GetDate() method.When i am creating any new user,in DateTime field Date is coming correctly time is not coming correctly,it should show generate always system date and time.Ex:2/6/2009 12:00:00 AM,2/7/2009 12:00:00 AM,2/8/2009 12:00:00 AM etc. I mean here date is changing but system time is not changing. H...
What tools do you guys recommend for backing up files and SQL Server databases on Windows 2003? I'm looking for tools to run daily backups of both files and SQL Server databases. Compress them up and stick them on NAS drives. I'm looking for cheap / FREE options if possible. ...
I'm designing a table in SQL Server 2008 that will store a list of users and a Google Maps co-ordinate (longitude & latitude). Will I need two fields, or can it be done with 1? What's the best (or most common) data-type to use for storing this kind of data? ...
I'm designing a database scheme right now and I figure just to be safe I should use nvarchar for my textual column's datatypes (for unicode support). While I don't expect non-english text I figure it would be better to have support it from the begining just in case. Is there any reason why I should stick with plain varchar? Performance...
For a school project I'm making a simple Job Listing website in ASP.NET MVC (we got to choose the framework). I've thought about it awhile and this is my initial schema: JobPostings +---JobPostingID +---UserID +---Company +---JobTitle +---JobTypeID +---JobLocationID +---Description +---HowToApply +---CompanyURL ...
Is it possible to configure multiple database servers (all hosting the same database) to execute a single query simultaneously? I'm not asking about executing queries using multiple CPUs simultaneously - I know this it possible. UPDATE What I mean is something like this: There are two 2 servers: Server1 and Server2 Both server host ...
I've been trying to specialize into the MS SQL server technologies, but my job has required me to understand more MySQL recently. Has any MS SQL DBA or developer had to do this, and if so, what were their biggest challenges? At the moment, for me: Lack of decent IDE No easy ETL tools like ssis ...
I have a task at hand of creating some kind of logic for a database. There is a IBM MQ Series setup in place today that replicates data from a couple of remote systems. At the moment it changes in the remote system and dumps the data into a staging table in a SQL Server 2005 database. I want to validate the data according to some simpl...
Hi I'm wondering if anybody has had any experience querying a Team Foundation Server store to retrieve current work item information. It is my understanding that the information I require is stored in the TFSWarehouse Database. I'm well aware that there are APIs that provide this functionality and I've used them myself. However these co...
I'm perverted in the sense that I hate exploring code and database structures in a tree view and I'd much prefer using something like the Powershell for that. Most of the stuff I need to do in SQL is exploring, i.e. looking at what columns does a table have or what does a particular stored procedure do. Looking at table columns is as e...
I need to migrate extremely large quantities of data (millions of files, Terabytes of data) to an SQL cluster. The migration process is partitioned into weekly migrations, with a few hundreds of new users (i.e request-generators) every week. So far things have run pretty smoothly, but lately i've discovered that the SQL cluster started ...
When I attempt to set an application role on a SqlConnection with sp_setapprole I sometimes get the following error in the Windows event log... The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated security contex...
The option "RETURNS NULL ON NULL INPUT" for a scalar UDF (see CREATE FUNCTION) stops the function body executing if the parameter is null and simply returns NULL. That is, it short circuits. Does anyone know how it handles multiple parameters? It would be useful to short circuit a function call with multiple parameters, say if the fir...
One of my clients wants me to perform a periodic "real" destruction of some of his old data, and I'm evaluating the best way to do it. The data is in a table, and I want to destroy some of the rows contained in it. I could do it manually by deleting/exporting the database on another computer/degaussing the hard drive/reimporting the sa...
Part 1: In a Microsoft SQL Server 2005 failover scenario, how can the databases be queried to determine which server is the master and which server is the slave? I'm looking for something more elegant than attempting to query on the server and see which one throws an exception. Part 2: Is there a way to monitor and determine when the ...
I'm using SQL Server 2005. Our application almost never deletes without it being a logical delete and therefore we have no need for cascading deletes. In fact, its quite a comfort knowing that the foreign key contraints give us some protection against an accidental delete statement. However, very occasionally I need to delete a top le...
I have an SSIS package to load data; as you may recall there are flags that are in data files as Y/N char(1) when I am trying to load them as bit flags into SQL Server. I am specifying the columns in the data file as String [DT_STR] and I have a data conversion task to convert them to booleans based on the following expression (I receiv...