Description:
Microsoft's SQL Server and related products.
|
|
|
Bind Variable Dramatically Slows Query: ASCII vs Unicode mismatch
|
| |
I was building a table-valued function that included this in the WHERE clause: AND tab.SOME_COLUMN = '0148' I wanted to drive the query with a parameter and changed the WHERE statement to this: AND tab.SOME_COLUMN = @SOME_VARIABLE_CD Simply substituting the variable for the literal caused the query to... more »
|
|
|
nike clothing,nike shoes,online store,http://www.maidi2008.net air Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hood
|
| |
nike clothing,nike shoes,online store,[link] air Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air Jordan, Bape Hoodies,Bape shoes-Tencent Traveler|Jordan Shoes,Nike Air Jordans, Air Force Ones,Retro Air... more »
|
|
|
Password Reset Best Practice?
|
| |
Hi. Could somebody outline what the best steps are for password reset on a site? I notice often that when I request a password reset from another site, they send an guid of some sort eg: click on the following link: [link] How exactly is this working on the back end and is this approach... more »
|
|
|
sequences or emulation of them
|
| |
Hi! Beeing new to sql-server I look for some pointers. I have a system, written for Oracle that uses sequences in order to get a primary key value. I see that that is not supported in sql-server, at least not in 2005. Is there any common practice to deal with this? (Thinking of porting it to sql-server)... more »
|
|
|
John Abraham moved to Bandra recently
|
| |
celeberties living style you want to know This site contain information about luxury living includs (houses,cars,hotels) video and informative knowledge see it for more details [link] Request :-check the add get information if you interested then order... more »
|
|
|
tracking Update, insert, delete during/after replication
|
| |
All, I posted under another thread titled "Trigger, Identify Insert, Update AND delete in one " because I was thinking a trigger was the way to go, but now I'm looking for a better idea from people with experience in replication I'm trying to create a table of tracking records for a replicated table. Example: I have table myReplicatedTable (id int, name nvarchar... more »
|
|
|
Trigger, Identify Insert, Update AND delete in one
|
| |
Sorry for the newbie question, but I would like to simply populate a tracking table with 'I', 'U' or 'D' (and the PK id) based on the type of change being made to the table with a trigger. My question is: Do I have to query all the psuedo tables to do that? ? Or is there an easier or mor efficient way? Do I need to create 3 triggers and do... more »
|
|
|
SQL 2008 Mirroring - failover looses owner
|
| |
I have successfully configured mirroring in SQL 2008. I use a witness server and it is running in sync mode. I can fail over the databases and everything works great; except one thing. I have a SQL user called dmbuilder. When I created the database via SMSS I edit the properties of the database, choose files and change... more »
|
|
|
Sys objects
|
| |
i have Several Databases with the Same view in them (vCustomers) I have to do work on these views (drop , modify etc) depending on the Data Sent to us via partners i have a Master database ( mymaster) well say and 30 other databases representing customer data i want to put a proc in Mymaster and query any one of the other databasses... more »
|
|
|
