|
|
-
aasim abdullah Posted 8 Months ago through Blogs
To resolve a problem, sometime we start thinking at high level while, simple solutions of said problem are available. This is what happened to me, when one of my colleagues (Tehman) asked me how to swap two column values in a table.My answer was, create...
|
-
aasim abdullah Posted 8 Months ago through Ask
Hi everyone,
While importing data from EXCEL 2007 (xlsx files). Import wizard only shows source data length to varchar(255), as compared to varchar(max) in EXCEL 2003 and prior versions (xls files). How to fix it ???
I have tried to import data using ...
|
-
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
-
aasim abdullah Posted 8 Months ago through Blogs
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
-
aasim abdullah Posted 8 Months ago through Blogs
Problem: On production servers, how to detect long running sessions and kill them automatically if they are exceeding a specific amount of time.Solution:Solution to this problem is very simple. Just create a job, which will detect long running sessions...
|
-
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
-
aasim abdullah Posted 9 Months ago through Blogs
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
-
Recently, I have joined Microsoft Virtual Academyand found it an amazing, free, trusted and up to date source of learning about Microsoft Cloud Technologies. Being a student of SQL Server, I was found 5 interesting tracks. You can learn some advance top...
|
-
aasim abdullah Posted 9 Months ago through Blogs
Recently, I have joined Microsoft Virtual Academyand found it an amazing, free, trusted and up to date source of learning about Microsoft Cloud Technologies. Being a student of SQL Server, I was found 5 interesting tracks. You can learn some advance top...
|
-
Recently, I was asked to review, already written stored procedures for optimization purpose. During this review process I have found that a group of developers is regularly committing a big mistake. This group of developers believes that table hint NOLO...
|